Import Delimited HIPAA 997 X12

[Megawisdumb]

I've written a small DB to read an EDI X12 997 functional acknowledgment but can't get the import to work properly with the ~ delimiter. It loads it across the columns rather than in rows. Any advice would be greatly appreciated!

phil

 

[Megawisdumb]

Column vs Row

This is exactly what I need to automate the process. THANKS! However, I still can't seem to figure out how to get the ~ delimited data to populate the rows rather than columns. Every option I attempt on the import populates the columns instead of rows. What am I missing?

 

[Megawisdumb]

Word

I thought that would be the answer. It's odd though as this x12 format is used world wide. If I open the file in Word first and find ~ and replace with section breaks and save them import into access it works just fine. Do you know any way to replicate the find and replace functionality in Word in Access so I could place then prior to the Transfertext command?