Automatically import Excels

[Innerv1sion]

Greetings, I was wondering if the following is possible using MS Access:
Creating a folder with various Excels in them, all build up in the same manner (column names and such). Is it possible to create a Access Database that imports all these Excels using the correct header automatically? Ideally, when I insert a new Excel with the same template and I start Access it should import the new Excel to keep the database up to date.


Thank you for your help!

[CJ_London]

yes it is possible.

using the dir function you can loop through the files in a directory

something like

dim fname as string
fname=dir("C:\xlfolder\*.xlsx")
while fname<>""
    transferspreadsheet....or other alternatives
    fname=dir()
wend

see this link about the dir function - you may also be able to make use of the attributes parameter as well, although I never have