Save as Command Line
 

I need to save an .xls file as .csv without opening the spreadsheet. The
sender provides a datastream file with a .xls extension. We then open and
save the spreadsheet as .csv and process some Access applications against it.
How can I have Access convert the incoming file with a DoCmd?

Save as Command Line
 

If you can't open the file in excel and then save as a .csv and you have to use
DoCmd (an Access VBA command, right??), then maybe asking in a forum dedicated
to Access would be better.



SoDakRah wrote:

I need to save an .xls file as .csv without opening the spreadsheet. The
sender provides a datastream file with a .xls extension. We then open and
save the spreadsheet as .csv and process some Access applications against it.
How can I have Access convert the incoming file with a DoCmd?

--

Dave Peterson