 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Larry Dew
Guest
|
 Posted: Wed May 02, 2007 3:55 am Post subject: Copy a large amount of data |
 |
|
I need to append a large number of records into an MS Access DB (3232).
I am using a TAdoTable. What is the fastest way to do this.
Thanks |
|
| Back to top |
|
 |
Vassiliev V. V.
Guest
|
| Posted: Wed May 02, 2007 8:11 am Post subject: Re: Copy a large amount of data |
|
|
3232 records is not large amount. For MS Access TADOTable with server-side
cursor will work, look also at prepared TADOCommand. Also put your inserts
into transaction. For fastest results you can look at third-party components
that work on lower level than ADO (OLEDB or ODBC).
//------------------------------------------
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)
"Larry Dew" <ldew (AT) XEGsys (DOT) net> ???????/???????? ? ???????? ?????????:
news:4637c533$1 (AT) newsgroups (DOT) borland.com...
| Quote: | I need to append a large number of records into an MS Access DB (3232). I
am using a TAdoTable. What is the fastest way to do this.
Thanks |
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
