How to copy a table from one database to another

[Paladyr]

A little while ago, someone tried to help me out with this but it ended up not working. Here is the code:

Set tdfTable = dbMaster.CreateTableDef("customers")
  With tdfTable
  i = 0
  Do
    i = i + 1
  Loop Until dbMaster.TableDefs(i).Name = "customers"
  .Name = dbMaster.TableDefs(i).Name
  .Connect = ";DATABASE=C:\Backups\3.mdb"
  .SourceTableName = dbMaster.TableDefs(i).Name
  
  dbBackup.TableDefs.Append tdfTable
[\code]

I want to take the table from dbMaster and copy it to dbBackup.  The variable tdfTable has the table name in it when I put it in the watch window, but it doesn't have all the fields and data, which is why I don't think it is working.  Isn't there like a simple method that will copy all properties of a table to another?  Thanks for the help!

 

[Paladyr]

Anyone????

 

[TURNERMICH]

Found this the other day, using ADO, seems a simple way of doing it, and it works fine.

http://www.planet-source-code.com/xq/ASP/txtCodeId.3510/lngWId.1/qx/vb/scripts/ShowCode.htm