Why extra lines when importing to Access?

D

DanaPharmer

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.
 
K

Klatuu

It appears your text file may have an extra line feed at the end of each line
causing a blank line.
 
Top