Issue importing a .txt file in to Access

gsilouisvilleic
gsilouisvilleic used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer
Commented:
Importing via Excel first and then Access i don't see any issues...just some records missing the "OBS" prefix...
I have attached my import to check it against yours.
Database7.zip
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
I linked it using "|" as the separator, and saw no errors.

Snip:
Test
Hamed NasrRetired IT Professional

Commented:
Some records where slightly different in length, so changed the field delimiter. My attempt was like Gustav's. Produced 9 fields.

Author

Commented:
I would like to thank you both for your fast respond, I greatly appreciated.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial