Code to combine multiple Excel files into one table?

[Best3435]

Have been trying to combine multiple Excel files in one folder to one table in Access. All excel files are the same format. Working with versions 2007 in excel and access. Will be appending the excel files to one table and each month an excel file gets added to the folder so need the capability to either combine all tables or choose files to combine would probably be better. Other option is to be able to select the excel file that needs to be appended to the table each month. Any help is appreciated on this topic, I will keep searching, any direction on where to search is a big help too, thanks.

 

[Best3435]

Appreciate any help anyone has to offer, thanks.

 

[cjcobra]

you should be able to "import" excel files into Access and pick which table to append them to. You can in-turn create an import template for each file afterwards.