Calling Excel Import wizard from DOS

D

Dane

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
 
T

Tom Ogilvy

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.
 
D

Dane

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

Tom Ogilvy

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

Calling Excel Import wizard from Dos 1
Which Excel event to call when opening a .txt file 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
import Excel worksheet to SQL Server table 7
Forcing Excel to Import .CSV data 2
Excel Import External Data Wizard 3
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top