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.
 
Back
Top