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

Import Data, using a command line switch
 

Is the File extension ".csv"?


"Balisteor" wrote:

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

Import Data, using a command line switch
 

No ".txt"


"Dead.Zone" wrote:

Is the File extension ".csv"?


"Balisteor" wrote:

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

Import Data, using a command line switch
 

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

"Dead.Zone" wrote:

Is the File extension ".csv"?


"Balisteor" wrote:

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

Import Data, using a command line switch
 

That does it .. THANK YOU.

"Dead.Zone" wrote:

Is the File extension ".csv"?


"Balisteor" wrote:

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