Save as Command Line

S

SoDakRah

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV Tab Delimited 4
Saving as CSV File 2
Best way to export from Excel to MySQL? 1
Creating macro to use on different workbooks 1
Why cant I save as a text file in excel? 1
save form 2
Save as csv file option missing from Excel 2007 3
csv not importing numbers stored as text 1

Top