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).

[!UWAGA]

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.

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

• User name
  Specify a user name for the database connection.

• Password
  Specify a password for the database connection.

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

• Advanced
  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.