how to run MS office program thru cmd

[habeeb4e]

Hi all,

Can u plz help me by showing some way to run MS office program like Access thru cmd command.

regards

[GX1_Man]

What are you trying to accomplish with this?

[habeeb4e]

I am trying to autmoate a process of importing txt files to multiple MS Access files. Thinking to have batch file that run each MS Access file separately and then thru Access I can import the txt files...so main objective is to open MS Access file thru the DOS batch file...

[Sidewinder]

The executable for Access is msaccess.exe, so yes you can run it from a batch file (you'll need a path of course).

There are not a lot of command line switches for Access. What are you planning to do once Access opens?

[ghostdog74]

Just for reference
http://support.microsoft.com/default.aspx?scid=kb;en-us;209207

[habeeb4e]

once Access open, I want to import txt files into predefined tables...
I am trying to make this process automated since I got too many txt files to be imported to multi Access mdb

[habeeb4e]

sorry...can I reformelate my question to be like this...I need the batch file to open specific Access programms then after that the thru Access I can import the txt files

Thanks

[Sidewinder]

From the reference posted by Ghostdog74, you can use the /x switch to run a macro when Access is executed. You cannot pass instructions from the DOS command line to Access.

An alternative way would be to write a script to create a Access object. The script would be able to pass instructions to the Access object.

Good luck.

[habeeb4e]

Thanks and Merry Christmas