🚀 go-pugleaf

If I am not wrong you have an Access db with multiple tables and you want to
copy one of these tables into another Access db. For this case i would do
the next:

1. Create database TrasportDB.mdb - use ADOX.
2. Copy table from source table into TransportDB.mdb with Select * Into
[TransportTable] in "FullPath\TransportDB.mdb" From SourceTable.
3. Deliver TransportDB.mdb on destination computer.
4. Copy table from TransportTable into DestTable with Select * Into
[DestTable] From [TransportTable] in "FullPath\TransportDB.mdb".

FullPath is the path to TransportDB.mdb and is different on source and dest
computers.

This way you will use native access methods that should be more reliable and
faster than using ADO methods.

If you need to perform more complete tasks you should use replication from
Microsoft Jet and Replication objects (import this typelib).

Regards,
Vassiliev V.V.
http://www.oledbdirect.com


"Peter" <p.krenz@web.de> �������/�������� � �������� ���������:
news:3cfdd7f1_1@dnews...
> Hi,
>
> I want to copy one table from ACCESS database X in Tokio :o)  to
> another ACCESS database Y in Melburne ... or better the contents of table.
> The structures of tables in X and Y are the same.
>
> How can I do that ?
>
> With dataset->SaveToFile(...) I can save the dataset (the content of
table)
> and after send it from Tokio to Melburne with dataset->LoadFromFile(...) I
> can load
> the contents, but it is not in the database Y.
>
> I've try it with dataset->UpdateBatch(arAll), but it doesn't work...
>
> (C++ Builder 5 pro ADO Express)
>
> thanks,
> peter
>
>
>