I am trying to convert some files from a legacy client application into our new replacement application.
The legacy app has an export feature and I exported all of the tables that were n the selection menu. The exports were all created with a file extension of .asc
These are recognized when I go thru the 'Get External Files' steps in Access. However, when they import every field is surrounded by bars '!' at the beginning of the filed and the end of the field.
I tried importing after revising the extension to .txt but the result was the same.
Does anyone have experience importing this type of file.
I attached a document that is a snapshot of what the imported records look like.
I also attached the raw exported file. I wasn't able to attach a file with an .asc extension so I revised the extension to .txt.