How do I import data from multiple Excel Files into Access at one.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We save the same excel file with production data with names that describe the
production run. We could have up to 20 files a day and I would like to
import all of these files into Access in a simpler way. Any Ideas?
 
Hi Cornelia,

If you search Google Groups for
"import all files in a folder" fallon excel
you'll find some sample VBA code.
 
Back
Top