Import Multiple Excel Files with SAME layout to Access

[torontoraptor]

Hi,



I was wondering how do I import/code in order to import multiple excel files into the database. I want to choose where specific data goes from excel into my fields in access but it will follow the same layout throughout.

thanks

[June7]

Options depend on exactly what you want to import from the Excel and where the files are.

VBA code can loop through files in a folder and import every Excel file it finds. Can use TransferSpreadsheet method if the Excel sheet structure is simple enough and only want sheet 1. The method can even reference a saved import specification. More complicated would be opening Excel objects and selectively grabbing data from sheets.

Common topic. Here is one recent thread https://www.accessforums.net/import-...ort-42980.html

[snipe]

I just had to do the same thing, here is my thread on it.

https://www.accessforums.net/import-...ess-43719.html

I manually imported the first file and checked to make sure the right data went to the right places. Ran that little function and 30 seconds later it was all done and all worked great.