trying to load data into Access autmatically using batch file

[bandi200]

Here is the batch file iam using to load data into access..it doesn't work. it executes the first command and creats crap.out but after that nothing happens..I scheduled this job in scheduler..is there any other way of d'ing it..pls send me the script if u have one which works to do this job..i really appreciate it. thanks

D:

cmd /c dir > d:\crap.out

CD\Program Files\Microsoft Office\Office
Msaccess.exe D:\shipping\shipment_daily.mdb /user reddy /pwd /x load

cmd /c dir > d:\crap1.out

 

[Bastien]

why not have access open the needed data file and import when opened? Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[bandi200]

No there shouldn't be any manual intervention. Every thing needs to be automated. And we dont even open the access. The access is only as staging area and other reporting tool will access the updated data...can some pls send me a BATCH file which can load data into Access in batch without any manual intervention..I appreciate it.

 

[cmmrfrds]

I have a series of bat files and one of the files executes Access. If you want a copy of the directory and all the supporting data, give me an email address and I will send.

 

[bandi200]

Hi,
I really appreciate ur help. Pls find below is my email ID..
U can mail the stuff to the same.

gnreddy@lycos.com

Thanks Again