• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

Copy access row from one dabase to another

I have two database A.Mdb and B.mdb. Both have the same table pessoa. I want to copy one specific  row from A.pessoa and copy to B.pessoa. Usind ADODB in visual basic 2008
0
Jose Bredariol
Asked:
Jose Bredariol
  • 2
1 Solution
 
CodeCruiserCommented:
Is using ADO.NET an option?

Dim dbcon1 as new oledbconnection(connectionstringforA.mdb)
dbcon1.open
dim dbcmd1 as new oledbcommand("Select ... From ... Where ...")
dbcmd1.connection = dbcon1
dim dbreader as oledbdatareader = dbcmd1.executereader

dbreader.read

dim dbcon2 as new oledbconnection(connectionstringforB.mdb)
dbcon2.open
dim dbcmd2 as new oledbcommand
dbcmd2.connection = dbcon2
dbcmd2.commandtext= "Insert Into ... Values .. " & dbreader.item("columnname") & ", " & dbreader.item("anothercolumnname") ...

dbcmd2.executenonquery()

dbcmd2.dispose
dbcon2.dispose
dbreader.close
dbcmd1.dispose
dbcon1.dispose
0
 
Jose BredariolPMPAuthor Commented:
Thanks
0
 
CodeCruiserCommented:
Do you mind explaining the grade?
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now