TransferSpreadsheet Query

[Access Virgin]

I am looking to use the DoCmd.TransferSpreadsheet function. I can get it to work but i have just a query regarding this. Is it possible to import records from a spreadsheet that have blank fields?

When I was testing out my code I could import 90 records instead of 130, the 40 that didnt import had the last field in the row left blank. The problem is that this filed is for comments and may not always be populated.

Any thoughts?

 

[FoFa]

What is the field in your receiving table set to? Can it receive zero length strings or is it required? Something in that maybe stopping it from receiving those blank fields, OR as sometimes happens, the blanks are misleading you from some thing else that is causing it.