[AccessD] Excel to MDB

Arthur Fuller fuller.artful at gmail.com
Thu May 10 10:46:07 CDT 2007


Imagine this, if you will:

A potential client invented an Excel system for doing estimates and orders.
Each estimate or order is a separate file. There are subdirs named for each
client. There are now hundreds of Excel files.

Now the potential client has realized the error of his ways and wants to
import everything into an Access db and stop using Excel.

I haven't seen the data yet, so I can only hope and pray that the Excel
files all work from the same template. Otherwise all hell breaks lose.

But supposing that in this best of all possible worlds, all the Excel files
are structurally similar. I already know how to talk to a given Excel file
and extract its contents into various tables. What I don't know is how to
walk the directory tree and examine and extract from every file I find in
said tree. I think it has something to do with the Dir() function, but I've
forgotten.

TIA,
Arthur



More information about the AccessD mailing list