🚀 go-pugleaf

SELECT * INTO [DstTable] FROM [SrcTable] IN "C:\Temp\Src.mdb"

You will need to recreate all indeces and relationships manually. Another
solution is to compact (or just copy) old db file into new one.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"siraj" <siraj.sm@omnisens.ch> �������/�������� � �������� ���������:
news:40aa4d8e@newsgroups.borland.com...
> Hi!
>  I use ADO components to connect to MS Access 2000 . I am using c++
builder
> 5.
> Periodically I have to create new databases  and copy some tables along
with
> the data  from the old
> database to the new database.  The old database and the new database are
> identical in structure. I create new access 2000 database using the
> components derived from importing the type library "Microsoft ADO Ext. 2.6
> for DDL and Security".
> How can i copy the tables from one access 2000 database to another access
> 2000 database?
> I have to even copy the relationships between the tables and their data
and
> overwrite the empty tables in the new database.
>
> Regards,
> siraj
>
>