Using Access VBA and Excel to scrub and import a CSV file
Posted on 2002-07-29
I am using Access 97 VBA to open a CSV file using Excel 97, trim the key column, and then import it into an Access table, maintaining the CSV format until it gets to Access.
My problem is this: When VBA goes to save the file in Excel as a CSV, Excel still asks me if I want to convert to Excel 97 format. Meanwhile, my Access VBA code continues to run and tries to open the CSV file that is supposed to be saved, closed, and available.
Is there a way to turn off this convert to Excel 97 prompt?
Thanks in advance for your help.