Code to combine multiple Excel files into one table?

Best3435

New Member
Joined
Feb 2, 2010
Messages
14
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.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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.
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top