Need help with ADO tables

Thread View: alt.comp.lang.borland-delphi

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Deon Joubert Mon, 17 Mar 2003 10:39

#144

Author: Deon Joubert
Date: Mon, 17 Mar 2003 10:39

8 lines
2224 bytes

Please reply to my email address and the newsgroup.  I need to move data
from an Interbase table to a MSAccess table, what is the best way to do
this?  At the moment, I open the interbase table as a TQuery and the Access
table as a TADOTable and then move each record with the append function, but
there must be a better and faster way to do this.  Any help will be
apprciated.  Please be very explicit in your answers as I have no experience
with ADO or other non-native (to Delphi) database connectivity.  Thank you
kindly.

Re: Need help with ADO tables

#145

Author: Marijn den Exter
Date: Mon, 17 Mar 2003 12:27

18 lines
2541 bytes

Delphi ships with the Datapump tool. This should do the job just fine. (I
think it uses the TBatchMove component internally)

"Deon Joubert" <dhj@3i.co.za> wrote in message
news:3e75a606$0$237@hades.is.co.za...
> Please reply to my email address and the newsgroup.  I need to move data
> from an Interbase table to a MSAccess table, what is the best way to do
> this?  At the moment, I open the interbase table as a TQuery and the
Access
> table as a TADOTable and then move each record with the append function,
but
> there must be a better and faster way to do this.  Any help will be
> apprciated.  Please be very explicit in your answers as I have no
experience
> with ADO or other non-native (to Delphi) database connectivity.  Thank you
> kindly.
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads