Importing CSV file

[Hemish]

Hi

I have attached a txt file which should be a csv file but it did not accept it as an attachment.

Ok here is the problem, i am importing the CSV file into MS Access 2000 and it imports into a new table without any extra blank records. But if i import the same file into MS Access 2010 i get an extra blank record. Do you know why this would happen in MS Access 2010, bit puzzled. Also a way to overcome this

Thanks

 

[Bryan]

I didn't get an extra record importing into 2010, but I did notice that you have about 30 CR/LF's in your file. Try opening in notepad, move the cursor to the bottom of the file and then backspace bringing the cursor to the end of line one.

You should, however, have something like a required criteria in at least one of the fields if you are importing to an existing table. This would result in any blank lines being thrown out and also alleviate the problem.