Why extra lines when importing to Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get every other line blank when importing a .txt file. If I let Access
assign key then the blank lines are numbered. Odd numbered lines have data.
Even numbered lines have no data. I can filter and delete them out but I use
a spec file to build the tables and I then run macros against it that blow up
because of the blank lines.
 
It appears your text file may have an extra line feed at the end of each line
causing a blank line.
 
You must log in or register to reply here.

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

Export: Every fourth line of data is extra/blank! 2
How do I export a access report without it inserting extra lines? 2
Access crashes when I try to import an excel file 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do I add invoice line numbers when importing 6
Import txt file - records on multiple lines 1
Importing Text Files Into Access 1
Importing Fixed Length File into Access 2007 1

Back
Top