Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kallileo
Starting Member
21 Posts |
 Posted - 2008-04-17 : 06:33:20
|
| Hi guysI have 2 mdb files with the same structure. I have a small C# app where the user can uses OpenFileDialogs to choose both files and update the tables in the first mdb with data form the second mdb. I use dataset Merge method to update the file but it's not the best way performance wise.How can I link these two mdb files in C# so I can directly execute Sql Queries like INSERT INTO mdb1.table1 SELECT * FROM mdb2.table1?Thank you |
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-17 : 13:31:48
|
| try to do this in a sp.insert into database1.dbo.mdb1select * from database2.dbo.mdb2and call that sp from c# app |
 |
|
|
kallileo
Starting Member
21 Posts |
Posted - 2008-04-18 : 04:45:07
|
| The problem is that the user will have to browse for the files...Is it possible somehow to pass the paths to the mdb files to the sp?I will probably have to use sp_addlinkedserverhttp://msdn2.microsoft.com/en-us/library/ms190479.aspx |
|
|
|
|
|
|
Linking two mdb files in C#