I need to automate the process of loading the Access from a flat file. 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.
Iam trying to execute the following script..the first part works but the rest doesn't..pls help me
D:
cmd /c dir > d:\test.out
CD\Program Files\Microsoft Office\Office
Msaccess.exe D:\shipping\shipment_daily.mdb /user reddy /pwd /x load
cmd /c dir > d:\test1.out
Iam trying to execute the following script..the first part works but the rest doesn't..pls help me
D:
cmd /c dir > d:\test.out
CD\Program Files\Microsoft Office\Office
Msaccess.exe D:\shipping\shipment_daily.mdb /user reddy /pwd /x load
cmd /c dir > d:\test1.out