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