Import Data, using a command line switch



Hello all.

I would like to know if it is possible to open a comma delimited text file
without going through the import data wizard.
I want to be able to use a command line switch or if there are default
import settings that I can set so that when i have Excel open the text file
it will import it correctly without any user input.

Thank you for you reading :D


Sorry let me redo that. Yes it is a file containing comma seperated values.
but saves as a ".txt" file.

Is all i need to do is rename it to ".csv" ?
Sep 2, 2009
Reaction score
what syntax and switches did you use to get the file to open into the columns in Excel correctly?

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