MS Access - Batch Import Excel Files

[richkoi]

MS Excel 2000 => MS Access 2000

PROBLEM:
I have multiple Excel files that I need to import into Access. All the files have identical headers to the Access table that I would like to import them into.

It is very tedious to use File=>Get External Data=>Import and then go through the Import process for each individual file.

MY QUESTION:
Is there a way to do a batch import, or set up a Macro to do a batch import of Excel files?

Thanks for your help, it would save me a ton of time if I can learn how to do this.

Rich

[delphist]

I found one works for me, try
docmd.transferspreadsheet, , , , ,
check the Access help for more.


MS Excel 2000 => MS Access 2000

PROBLEM:
I have multiple Excel files that I need to import into Access. All the files have identical headers to the Access table that I would like to import them into.

It is very tedious to use File=>Get External Data=>Import and then go through the Import process for each individual file.

MY QUESTION:
Is there a way to do a batch import, or set up a Macro to do a batch import of Excel files?

Thanks for your help, it would save me a ton of time if I can learn how to do this.

Rich