Help! Import multiple excel files automatically to Access database

[Ingrid L.]

Hi! I'm a novice and new to this board.
Need some help pls.
I have an access database built by a contractor who used VB language to run
a macro or script that would automatically update the database from multiple
excel files that were dragged and dropped to a folder.
We can't find the contractor now to make changes to the database so we built
a new one.
our internal expert has Access expertise and can create a macro that will
update the database so long as it's from one source file.
Clearly it can be done we just can't figure out how to do it.
Can anyone point me in the right direction?
Thanks in advance.
Ingrid

 

[Roger Carlson]

I'm guessing you need to just create a loop around your in-house developer's
code that will read each file in the folder and import the data.

There are some elegant ways to read filenames in a folder by programming the
File System Object, but on my website (www.rogersaccesslibrary.com), is a
small Access database sample called "Directory" which is a quick-and-dirty
DOS batch file to do the same thing. The result will be a table in your
database with the filenames of each file that you could use to loop through.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L