Import Multiple Spreadsheets

  • Thread starter Thread starter CompassDBA
  • Start date Start date
C

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!
 
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.
 
Thank you. I'll give it a try.

John said:
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.
Click to expand...
 
Back
Top