December 12th, 2003, 02:19 PM
convert the database?
is there any method by which can i convert the MSSQL database backup into MS ACCESS format???????
December 12th, 2003, 07:06 PM
You can use DTS to convert data from SQL to access.
December 13th, 2003, 01:48 AM
Or Access has an import from ODBC datasource feature.
December 13th, 2003, 12:16 PM
Thanx for the suggestions
December 13th, 2003, 12:21 PM
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.