Pipe Delimited Text File Import Question

Amileaux

Registered User.
Local time
Today, 09:20
Joined
May 6, 2003
Messages
98
I have received two very large files that are "pipe" delimited. I can't seem to get Access to recognize the delimiter. On the second screen of the import text wizard I have selected Other and have tried to select the | with no success. It is recognized here (I used shift + the key above the enter key \) and in Excel. I can import into excel except that the entire file does not load due to its size. Why will excel recognize |, this format recognizes | but access will not? Any ideas. If using Visual Basic would be preferred I have dabbled in that a bit. Thank you . Marie
 
When in the import wizard, use the ADVANCED button (bottm left) and then enter the pipe character in the field delimiter, works for me.
 
Thank you! It worked. Marie
 

Users who are viewing this thread

Back
Top Bottom