Why extra lines when importing to Access?

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

Guest

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

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
Importing Fixed Length File into Access 2007 1
Importing Text Files Into Access 1
Import txt file - records on multiple lines 1
Import with access defined primary key from macro 1

Top