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

transfertext delimited 1
Lose primary key when importing 3
Import Specification 12
Import csv file to Access 2003 table 2
Access Project SQL Import csv 4
Import files into access 1
Import Specs Changed "Magically" in Midst of Loading Sequence 3
Need to grab Path and Filename to run Import txt file process... 19

Top