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

C

Cornelia

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?
 
J

John Nurick

Hi Cornelia,

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