Answer» Hi all,
Can u plz help me by showing some way to run MS office program like Access thru cmd command.
regardsWhat are you trying to accomplish with this?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... 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?
Just for reference http://support.microsoft.com/default.aspx?scid=kb;en-us;209207once 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 mdbsorry...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
ThanksFrom 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. Thanks and Merry Christmas
|