Hi everyone,
I am new to this forum. Not sure if this is the appropriate section but I hope somebody could help me.
Basically I am looking for a VBSCript that will Open an Access File say for example C:\Access\TEST.MDB
Then it will automatically update the Table inside.
I have 2 tables on this MDB file, Table1.xls and Table2.xls.
I would like Table1.xls to be replaced by Table3.xls

All the XLS file are also on the same location C:\Access\.
I do not know much on Access but just trying to play around with it.
Appreciate any help.

Thanks.
Cross