Help!!

[slyvsspy]

I am importing a CSV file with 700 records using a macro function "transfer text". When I import the file, it only shows 278 records.

Does anybody have any idea what is going on??

Just any idea you might have because I am clueless!

 

[simongallop]

When you import the table does Access create a new table called nameoftable_ImportErrors?

 

[slyvsspy]

Yes it does, I removed the primary key and everything works fine now.

Is that what you were going to say?