[AccessD] Excel to MDB

A:

Use File Scripting Object.  Do you have to look at all the worksheets in the
workbook too?

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, May 10, 2007 8:46 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Excel to MDB

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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.6.6/795 - Release Date: 5/9/2007 3:07
PM