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

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

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

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