i have 2 database (access,SQL) with 2 different connection string
i want to select a table from the first database
insert it to the second database
any help
netisland
0
Newbie Poster
Recommended Answers
Jump to Post1 connect to first database.
2 select data from table into corsor or result set.
3 connect to second database.
4 insert the result set(cursor) in table.
All 4 Replies
Alberto Bucur
0
Junior Poster
1 connect to first database.
2 select data from table into corsor or result set.
3 connect to second database.
4 insert the result set(cursor) in table.
netisland
0
Newbie Poster
if you please give me the code
oussama_1
39
Posting Whiz in Training
ryanjayson
-4
Newbie Poster
Much better if you write it to yourself for you to get more familiar, then if you stuck post your code or error
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.