B
Beep Beep
I have roughly 500 invididual Excel files that are sent to me via the IT
department. Each file has roughly 5 - 10 thousand lines on them. What I am
wondering is, is there a Access VBA Macro that I could use to inport each one
of these 500 Excel files into a Access database while looping through them in
one Excel directory while I continue to do other things? The person that did
this last spend a day or so just importing them into Access and appending
them into one file. The final Access file contains apprsoximately 2.5 million
records.
PS: I think I originally posted this in the wrong site.
Thanks
Frank
department. Each file has roughly 5 - 10 thousand lines on them. What I am
wondering is, is there a Access VBA Macro that I could use to inport each one
of these 500 Excel files into a Access database while looping through them in
one Excel directory while I continue to do other things? The person that did
this last spend a day or so just importing them into Access and appending
them into one file. The final Access file contains apprsoximately 2.5 million
records.
PS: I think I originally posted this in the wrong site.
Thanks
Frank