I'm importing various Excel spreadsheets and sometimes the data being
imported is different.

By different I mean rows can be in the wrong order or, more worrying, not
all rows will be imported. If I try again it will work. For some imports
that require keying on a specific phrase in the imported file that is
precisely what I'm doing - I simply import again and it works.
Further testing reveals that incorrect imports can happen seemingly randomly
even after they initally appear to work.

I'm using this code;

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tmpNew",
VFileName, 0


Questions;

Why is this happening?

And should I try to determine the Excel type before I run the code? I've
settled on acSpreadsheetTypeExcel8 but could this be a problem when
importing from older or newer versions of Excel. I have accounted for Excel
4 which is not accepted as an error is trapped for that.

"a a r o n . k e m p f @gmail.com [MCITP: DBA]" <aaron.kempf (AT) gmail (DOT) com>
wrote in message
news:84f0250a-1bb8-4889-b22f-ecb0023a6186 (AT) o1g2000yqb (DOT) googlegroups.com...
you should get rid of excel entirely and have the data entry in Access


That would be lovely but it's unavoidable. Looks like I may be close to
solving it. Blank lines at the start can confuse Access so am deleting
those and it seems solid so far in testing. Else I may import as CSV.