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

Recommended Answers

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.

Jump to Post

All 4 Replies

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.

if you please give me the code

Click Here
go to VB .NET and Databases tutorials

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 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.