Importing a folders worth of excel work books into Acess

[chrisbrocco]

Is there a way (using VBA) to point to a folder and make access import all the files (which will be excel files) into a access a table.

Prefrably beable to say which colums it imports

 

[p4nny]

Hello,

I'm looking to utilize some of the within this thread.

Basically, I would like to code to import excel sheets from subfolders within a chosen directory. The excel workbooks have a "-" in the name so I would like to search using this.

Is this possible?

thanks in advance