yrf9320
May 25th, 2001, 06:44 AM
How can I convert a SQL Server database to an MSAccess database.
Click to See Complete Forum and Search --> : SQL Server to MSAccess
dave seddon
May 25th, 2001, 06:57 AM
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
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
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.