[AccessD] copying a table from every database in a folderinto 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