Importing data via macro

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

Liz - you're probably better off if you write your macro in Access, not
Excel.

That's not to say you can't do it in Excel. If you create it in Excel,
though, you are going to get into the details of creating an update/insert
query in Excel VBA and looping through each row of data in each of the files
to: a) fill in the query parameters, and b) call the ADODB code to execute
the query

In Access you can just programmatically import each of the Excel files




"Liz" wrote:

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