Calling Excel Import wizard from DOS

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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?
 
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

Which Excel event to call when opening a .txt file 1
import Excel worksheet to SQL Server table 7
Call command for Excel Wizard 1
Excel Import External Data Wizard 3
Forcing Excel to Import .CSV data 2
Access Subscript out of range when importing into access 2010 from excel 0
Import Data, using a command line switch 1
How to easily migrate PST to Zoho account? 0

Back
Top