Access is dropping rows on import

F

FloridaRay

I'm importing a csv file into Access 2003. when I import automatically using
DoCmd.TransferText acImportDelim it intermittently drops the first row. When
I import manually using the import wizard and same specification specs, it
doesn't. I get no "import error" table generated and I've verified that the
first row looks exactly like the 2nd row. I found one answer where the first
row may be missing a crlf but that's not the case in this case.

Has anyone else experienced this and how did you fix it?
Many thanks for your help!!
 
P

pietlinden

I'm importing a csv file into Access 2003.  when I import automaticallyusing
DoCmd.TransferText acImportDelim it intermittently drops the first row.  When
I import manually using the import wizard and same specification specs, it
doesn't.  I get no "import error" table generated and I've verified that the
first row looks exactly like the 2nd row.  I found one answer where thefirst
row may be missing a crlf but that's not the case in this case.

Has anyone else experienced this and how did you fix it?
Many thanks for your help!!
Click to expand...

Sounds like you're specifying that the first row contains header
information... Are you?
 

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

3625 error 1
Import new .txt file only. 5
transfertext delimited 1
Cannot import CSV file into ACCESS 1
Access 2003 versus Access 2007 Excel Import 0
Lose primary key when importing 3
need help with syntax for docmd.transfertext, ontimer event 5
Import Specs Changed "Magically" in Midst of Loading Sequence 3

Top