Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Excel Text Import Wizard - bug | Excel Discussion (Misc queries) | |||
excel import external data wizard | Excel Discussion (Misc queries) | |||
Excel Text Import Wizard | Excel Discussion (Misc queries) | |||
Excel Text import wizard | Excel Discussion (Misc queries) |