[AccessD] copying a table from every database in a folder into another database

Stuart,

Thanks for the speedy reply. The append to a single table is the next step
after some massaging and the tables are in three different layouts: AP, AR
and ONH. I have to append three columns to each table and parse the table
name into parts for source, ERP, and location. Table name is like
11iARAgingC06, where the first three or four characters are for ERP type, ie
Oracle 11i or 1103, after that comes either ARAging, APAging, or OnHold, and
following that is a three digit location code.

I just pulled the zipped Monarch folder off my thumb drive and am going to
try it out.

Once again, Thanks

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Wednesday, August 11, 2004 11:13 PM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] copying a table from every database in
afolderinto another database


On 11 Aug 2004 at 22:54, JMoss wrote:

> the same as the database. How can I append a table from each database into
> another Access database?

Just read this again. Do you mean you want to append all of the other
tables into one. If so, you;ll need to add another couple of lines to my
previous post. Include this before the "strFIlename = Dir$()"

Currentdb.Execute "Insert into myTable select * from " &  strTablename
DoCmd.DeleteObject acTable, strFilename




--
Stuart


--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com