Issue importing a .txt file in to Access
I have a .txt file and i am trying to import it in Access but when i do some of the records are shifted over the next column. Does anyone know how to fix this?
thank you
Test-File.txt
thank you
Test-File.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hamed Nasr
Some records where slightly different in length, so changed the field delimiter. My attempt was like Gustav's. Produced 9 fields.
ASKER
I would like to thank you both for your fast respond, I greatly appreciated.