#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    india
    Posts
    22
    Rep Power
    0

    convert the database?


    hi,
    is there any method by which can i convert the MSSQL database backup into MS ACCESS format???????


    Rinkesh
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    BC, Canada
    Posts
    32
    Rep Power
    11
    You can use DTS to convert data from SQL to access.
  4. #3
  5. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    Or Access has an import from ODBC datasource feature.
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    india
    Posts
    22
    Rep Power
    0
    Thanx for the suggestions

    Rinkesh
  8. #5
  9. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,445
    Rep Power
    4539
    You'll probably have to review the resulting db if you are importing the structure. There are quite a few differences between SQL Server and Access datatypes, any Stored Procedures won't import into Access, etc.

IMN logo majestic logo threadwatch logo seochat tools logo