records missing when linking to a text file

N

Nico

I have a .txt file which I try to link into Access 2007. However when I open
the table in Access, some records are missing. I have tried it on two
different computers and get the same results. Does anyone know anything
about this and how to overcome it? Thanks

PS the same happens when I import rather than link
 
N

Nico

I answered my own question: quote marks were the key. However, the records
above and below a specific one that was missing also had the same amount of
quote marks, but appeared in the linked table. Anyone knows why this would
be ?


Thanks
 
Top