Hi,

I want to create a macro, which let me automate the process of importing the
data from various files (*.xls) from a particular directory to the main table
in MS Access.

My Main table in access is called Wire Transfer Main table. And every
Monday few specialist go in a share drive and post their completed forms in
..xls format. My macro should go into that shared directory every week and
pull out the files from that directory and copy the data from those files to
my Wire Transfer Main Table in access database.

Please help.

Thanks