Import Data, using a command line switch

B

Balisteor

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
 
B

Balisteor.

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

granny7993

Joined
Sep 2, 2009
Messages
1
Reaction score
0
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

Similar Threads

Import Data, using a command line switch 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import External Data 1
Text Import Wizard 1
Command line switches - possible 2
Data Import Question 4
Where is the Data Import Excel button in Excel 2007 6
Importing Text Files Into Access 1

Top