TransferSpreadsheet skips rows

[Chad Cameron]

Hi All,

I am using the transferspreadsheet to get data into my table. It's range is
A1:H50.

In my spreadsheet, occasionally Column H is blank. When I import the
spreadsheet, it skips all rows where Column H is blank.

Any ideas on how to fix this?
Chad

 

[Chad Cameron]

I copied this marco command and it seemed to work. Not sure my the builtin
macro didn't. I saved the spreadsheet as a CSV.

DoCmd.TransferText acImportDelim, "", "Table1", "C:\Winxp\testing.csv",
True, ""

Code from:
http://www.ozgrid.com/forum/showthread.php?t=32942