[AccessD] Excel to MDB

Arthur,

I have a 'thrown together' db in A97(very ugly)...but you point it at a 
folder/directory...it goes in and creates a table with every folder and 
subfolder.  The next pass it uses these folder names to search for *.mdb(can 
be changed to *.xls) and records size and location.

The first loop is not very efficient but it gets the job done, I just never 
had time to tweak it.

It might be suitable for your situation.  I can send a copy off-list if you 
like.

Thanks,

Mark A. Matte


>From: "Arthur Fuller" <fuller.artful at gmail.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: [AccessD] Excel to MDB
>Date: Thu, 10 May 2007 11:46:07 -0400
>
>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
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Like the way Microsoft Office Outlook works? You’ll love Windows Live 
Hotmail. 
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_outlook_0507