Calling Excel Import wizard from DOS

G

Guest

We wish to call the Excel Import wizard also called <import External data>
function
from a DOS command and thereby format the txt file via the wizard.

The command will be called from an AS400 server.

Can anybody help
 
G

Guest

That part of Excel interfaces to ODBC. I think you want to use ODBC rather
than Excel. You might search google for ODBC to see how you might use it.
 
G

Guest

hi Tom
maybe I misunderstand your point. However we do wish to use Excel and the
incorporated Text Import Wizard.
But mayby you are talking about how to call the API?
 
G

Guest

In DOS you could try

excel.Exe "C:\Myfolder\Myfile.txt"

and see if it brings up the text import wizard.
 

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

Excel Import External Data Wizard 3
import Excel worksheet to SQL Server table 7
Forcing Excel to Import .CSV data 2
Which Excel event to call when opening a .txt file 1
Access Subscript out of range when importing into access 2010 from excel 0
Import Data, using a command line switch 1
Can I start the text import wizard automatically? 4
user to select path 5

Top