Export (0) Print
Expand All

Connect to a Microsoft Access Database (SSAS)

This page of the Table Import Wizard enables you to specify settings to connect to a Microsoft Access database. To access the wizard from the SQL Server Data Tools, on the Model menu, click Import from Data Source.

To connect to a Microsoft Access database, you must have the appropriate ACE provider installed on your computer. For more information, see Data Sources Supported (SSAS Tabular).

Note Note

The credentials of the current user are used when selecting a file in this page. However, import will not succeed if the user specified in the Impersonation Information page does not have sufficient privileges to read from the selected file.

Friendly connection name

Type a unique name for this data source connection. This is a required field.

Database name

Specify the full path for a Microsoft Access database file.


Navigate to a location where a Microsoft Access database file is available.

User name

Specify a user name for the database connection.


Specify a password for the database connection.

Save my password

Specify whether the password you have entered in the Password box is stored.


Set additional connection properties by using the Set Advanced Properties dialog box.

Test Connection

Attempt to establish a connection to the data source using the current settings. A message is displayed indicating whether the connection is successful.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft