Querying Access database from Analytica 64

Migrating Access Database to SQL Server Express 2008

Step 1. Installing the SQL Server Express 2008

Download the installer here: http://www.microsoft.com/web/downloads/platform.aspx

Here is a link to a video that goes through the installation of SQL Server 2008 Express: http://www.msdev.com/Directory/Description.aspx?eventId=1209

Pointer: Please check Management Studio Express while installing the SQL Server Express 2008. Management Studio Express lets you easily access, configure and manage SQL Server Express and SQL Server Databases. Please visit the following link to learn more about SQL Server Management Studio on MSDN: http://msdn.microsoft.com/en-us/library/ms174173.aspx.

Step 2. Installing the SSMA(SQL Server Migration Assistant) for Microsoft Access Databases

Link to download the SSMA installer
http://www.microsoft.com/downloads/details.aspx?FamilyID=133b59c2-c89c-4641-bebb-6d04476ec1ba&DisplayLang=en

Video: Overview and Installation
Link: http://www.microsoft.com/sql/solutions/migration/access/SSMA01.wvx

Step 3. Migrating Access database to SQL Server Express 2008

The linked video explains you step by how to migrate an Access 2003 database to SQL Server.

Video: Migrating Process and Settings
Link: http://www.microsoft.com/sql/solutions/migration/access/SSMA02.wvx

Pointers: Remember to check Link Access to have the option of accessing your database from Microsoft Access even after the migration.

More resources on SSMA tool.
http://www.microsoft.com/sqlserver/2005/en/us/migration-access-learning.aspx