Import Multiple Spreadsheets

[CompassDBA]

I have individual spreadsheets for each day of the month for November. Is
there a way to import them all at once into an access database?

Thanks!

 

[John Nurick]

You need to write VBA code that imports them in succession, e.g. using
the Dir() function to get the filenames and DoCmd.TransferSpreadsheet to
import them.

 

[CompassDBA via AccessMonster.com]

Thank you. I'll give it a try.

You need to write VBA code that imports them in succession, e.g. using
the Dir() function to get the filenames and DoCmd.TransferSpreadsheet to
import them.