How can I convert a SQL Server database to an MSAccess database.
Printable View
How can I convert a SQL Server database to an MSAccess database.
On SQL Server Enterprise manager (SQL Server 7), under the Tools menu is the option Data Transformation Services. This allows you to export data to a variety of databases, etc.
Alternatively, link from a blank Access database via ODBC to the SQL Server tables you want and qrite a few Make table queries that suck in the desired tables.
Hope this helps
Dave Seddon