locked
TSQL RRS feed

  • Question

  • i have a backup of ACCESS database and i want to restore it in sql server 2005.

    can anybody help me to sort out this problem?

    Tuesday, February 8, 2011 12:15 PM

Answers

  • 1) SSIS packages

    2) Linked Server

    3) OPENDATASOURCE

    SELECT   *
    FROM  OPENDATASOURCE(
     'Microsoft.Jet.OLEDB.4.0',
     'Data Source="C:\northwind.mdb";
     User ID=Admin;Password='
     )...Customers


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by WeiLin Qiao Friday, February 11, 2011 5:00 AM
    • Marked as answer by WeiLin Qiao Wednesday, February 16, 2011 10:22 AM
    Tuesday, February 8, 2011 12:47 PM

All replies

  • 1) SSIS packages

    2) Linked Server

    3) OPENDATASOURCE

    SELECT   *
    FROM  OPENDATASOURCE(
     'Microsoft.Jet.OLEDB.4.0',
     'Data Source="C:\northwind.mdb";
     User ID=Admin;Password='
     )...Customers


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by WeiLin Qiao Friday, February 11, 2011 5:00 AM
    • Marked as answer by WeiLin Qiao Wednesday, February 16, 2011 10:22 AM
    Tuesday, February 8, 2011 12:47 PM
  • 1) SSIS packages

    2) Linked Server

    3) OPENDATASOURCE

    SELECT   *
    FROM  OPENDATASOURCE(
     'Microsoft.Jet.OLEDB.4.0',
     'Data Source="C:\northwind.mdb";
     User ID=Admin;Password='
     )...Customers


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, February 8, 2011 12:47 PM