Importing all excel files from one folder

[Guest]

I would like to know if it is possible to import all of the excel files from
a specific folder into an Access table. The only way that I can accompolish
this now is to name each file in a macro....

 

[George Nicholson]

Using VBA you could probably use the FileSearch object (I've never actually
done this). It's FilesFound property is a collection of Files that meet the
search Criteria (e.g., all files in a specific directory with a .xls
suffix). You should be able to loop through that collection, importing
during each iteration.

Might require adding a reference to the "Microsoft Office x.x Object
Library" within the VBE, if you don't already have one.

HTH,