Calling Excel Import wizard from DOS
 

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
--
Dane

Calling Excel Import wizard from DOS
 

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.

--
Regards,
Tom Ogilvy


"Dane" wrote:

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
--
Dane

Calling Excel Import wizard from DOS
 

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


"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"Dane" wrote:

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
--
Dane

Calling Excel Import wizard from DOS
 

In DOS you could try

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

and see if it brings up the text import wizard.

--
Regards,
Tom Ogilvy



"Dane" wrote:

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


"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"Dane" wrote:

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
--
Dane