Importing

[J. Singerman]

Is there way to import multiple workbooks in one Excel
spreadsheet simultaneously? For example, if each workbook
represents a day in the month, is there way to get each
workbook into one Access table?

Thank you.

 

[Ken Snell]

You can't import them simultaneously, but you can import them consecutively
using VBA code. And so long as each workbook has the same data format. Check
out the TransferSpreadsheet action to see how this is done. You then need to
write a loop that gets all files in a directory and then imports each one.

Post back with more info so that we can give specific suggestions.