import multiple excel files

[jlg5454]

Hi,

I need to import the first sheet in all excel files from 12 separate folders. The range that I will need to import will match all field names on the table except one. The last field name will be a date field that I want to populate with the date on the file located on cell m3. Is there a way to have that date populate to the last field for every record imported. Thanks for any examples replied back.

 

[Remou]

You can run update queries after importing the spreadsheets.