Data Updation from Remote MDB to SQL Server

• Anantha_Marella

  Grasshopper

  Points: 13

  More actions

  October 6, 2007 at 6:36 am

  #179905

  Dear Folks,

  We are facing a problem when we try to update the data from Remote MDB to SQL server programmtically.

  Problem Description

  1) We have a Cleint / Server Applciation

  2) Some modules using SQL server and some of them are using MDB, those modules are using MDB are user specific, i mean to say there are multiple MDB s on same name in different user PCs.

  3) This Application is done in .NET 2005

  4) Now we have to Migrate these MDB data in SQL server and as well as we have to do the Merging of the data

  5) Initially we thought about doing this by using OPENROWSET method, and we got the problem by getting the Remote MDB in another PC.

  (In OPENROWSET we will use the MDB path and Provider, adn that MDB is in the same PC)

  Did any body worked in the same kind of work, please share with us.

  Waiting for some suggestions, how to do this.

  Thanks in Advance

  Anantha Marella

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  October 6, 2007 at 7:09 am

  #739786

  I guess, DTS or SSIS would possibly be the best solutions to the scenario...

  --Ramesh
  

  ---