 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
augusto
Guest
|
 Posted: Wed Dec 17, 2003 9:15 pm Post subject: update Acces table with 10000 rows |
 |
|
hi guys;
we have two tables (a and b) with 10000 rows in diferent Acces´s
data bases. A and B are equals.
we want to update A with the data in B.
which is the best strategy to make this.
thanks, any suggestion will be
appreciated
|
|
| Back to top |
|
 |
augusto
Guest
|
| Posted: Fri Dec 19, 2003 9:49 am Post subject: Re: update Acces table with 10000 rows |
|
|
thanks for the solution,
it'works well , the insert is done in 4 seconds, but my access database is
password protected:
I try many ways but i'can't find the correct syntax to include the parameter
'Jet OLEDB:Database Password=xxx'
for the source.mdb in the INSERT INTO.. IN statement
it works's without password
strSql := 'INSERT INTO [products] SELECT * FROM [products] IN
"C:testsource.mdb"';
Any help would be excellent
"Brian Bushay TeamB" <BBushay (AT) Nmpls (DOT) com> escribió en el mensaje
news:6sr1uvkb5tps5c4b5sd6j5fg95e8nh6aad (AT) 4ax (DOT) com...
| Quote: |
we have two tables (a and b) with 10000 rows in diferent
Acces´s
data bases. A and B are equals.
we want to update A with the data in B.
which is the best strategy to make this.
thanks, any suggestion will be
appreciated
assuming your TadoConnection is set up for the database where table A
resides
//Remove records from A
Delete from A
//Insert records from B
Insert into A
Select * from B in c:SomeDirectoryYour.mdb
--
Brian Bushay (TeamB)
[email]Bbushay (AT) NMPLS (DOT) com[/email]
|
|
|
| Back to top |
|
|
Viatcheslav V. Vassiliev
Guest
|
| Posted: Fri Dec 19, 2003 10:59 am Post subject: Re: update Acces table with 10000 rows |
|
|
INSERT INTO [products] SELECT * FROM [products] IN ""
[;DATABASE=C:Testsource.mdb;PWD=xxx]
//------------------------------------------Regards,Vassiliev V.
V.http://www.managed-vcl.com - using .Net objects in Delphi +
ADO.Nethttp://www.oledbdirect.com - The fastest way to access MS SQL
Server,MS Jet (Access) and Interbase (through OLEDB)
"augusto" <augustoizus (AT) sinectis (DOT) com.ar> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:3fe2c85c$1 (AT) newsgroups (DOT) borland.com...
| Quote: | thanks for the solution,
it'works well , the insert is done in 4 seconds, but my access database is
password protected:
I try many ways but i'can't find the correct syntax to include the
parameter
'Jet OLEDB:Database Password=xxx'
for the source.mdb in the INSERT INTO.. IN statement
it works's without password
strSql := 'INSERT INTO [products] SELECT * FROM [products] IN
"C:testsource.mdb"';
Any help would be excellent
"Brian Bushay TeamB" <BBushay (AT) Nmpls (DOT) com> escribió en el mensaje
news:6sr1uvkb5tps5c4b5sd6j5fg95e8nh6aad (AT) 4ax (DOT) com...
we have two tables (a and b) with 10000 rows in diferent
Acces´s
data bases. A and B are equals.
we want to update A with the data in B.
which is the best strategy to make this.
thanks, any suggestion will
be
appreciated
assuming your TadoConnection is set up for the database where table A
resides
//Remove records from A
Delete from A
//Insert records from B
Insert into A
Select * from B in c:SomeDirectoryYour.mdb
--
Brian Bushay (TeamB)
[email]Bbushay (AT) NMPLS (DOT) com[/email]
|
|
|
| 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
