Importing Delimited Text to MS Access: Step 4
On this screen you will tell MS Access how the file is delimited. Make sure that Other is the only delimiter selected and in the blank area type in a pipe (the pipe is [Shift] - [Backslash]). Click Next to continue.

If you require further assistance with the instructions or information on this page, contact the IT Support Center.