Certain values are missing when I import a pipe-delimited text file into access. I don't understand why this is happening. It works fine when I delimit the text in Excel. Why would Access omit certain values when importing text?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."

__________________
Julio Cesar

-\"Bueller.......... Bueller.......... Bueller.......... Bueller..........\"

Try saving the file as an Excel file first, using VBA. (Scripting.FileSystemObject) And then import it.

HTH

mmcdonal