Blank Fields / Linked Table issue

S

Steve

I am linking an excel spreadsheet via:

DoCmd.TransferSpreadsheet acLink, , "LinkedTable", strFilePath, True

The Spreadsheet contains blank fields. If I alter any data in the
"LinkedTable" thru Access, it corrupts the spreadshheet. For instance, if Row
1, Col 2 is blank, after altering the data in Access, Row 1, Col 3 moves into
the once blank Row 1 , Col 2.

Any reccomendations?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Multiple Worksheets - TransferSpreadsheet VBA 0
convert columns to rows 6
Sql Server linked table and NULL bit fields 2
"Blank" Lines Elimination ? 1
Hidden Excel mystery 0
Data not showing from Linked Excel 3
Row-specific data to one common field 4
Need macro to move to first blank cell in column 6

Top