Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Executing a query from two different connections???

Status
Not open for further replies.
krish1980

krish1980

Programmer
Feb 27, 2002
20
US
I want to select a few records from a local connection(access db) & insert the same into a remote database(sql server). Is it possible to update it like populating into a single recordset & the inserting the selected list with a single execute command??? Right now i'm reading each record & inserting it till eof in a do...while loop...

if any other alternative is there pls. suggest me........

regards,
krish. Krishnamoorthy
krish1980@rediffmail.com
 
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Start loop from a specified point
Replies
0
Views
342
penguinspeaks
penguinspeaks
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
363
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
Wrong code in a href ?
Replies
1
Views
369
leifoet
leifoet
leifoet
  • Locked
  • Question
How to check if a datatable is empty ?
Replies
0
Views
385
leifoet
leifoet
DiDYRO_
  • Locked
  • Question
How do I make a VBS file that can collect dialog-type answers in a local .log file?
Replies
0
Views
336
DiDYRO_
DiDYRO_

Part and Inventory Search

Sponsor

Back
Top