I have a .txt file that is comma delimited with " as text qualifier. This file has no returns, instead "" is found at the end of each record. I'm having trouble importing to Access or Excel. If I go in an manually enter a return between the double quotes it works fine. How can I get these files in without having to put in the returns? Some files are quite large.
using Access and Excel 2000
using Access and Excel 2000
