Connect to a Microsoft Excel File (SSAS)

This page of the Table Import Wizard enables you to connect to a Microsoft Excel file stored on the local machine. To access the wizard from the SQL Server Data Tools, on the Model menu, click Import from Data Source.

To connect to a Microsoft Excel file, 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.

• Excel File Path
  Specify a full path for the Excel file.

• Browse
  Navigate to a location where an Excel file is available.

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

• Use first row as column headers
  Specify whether to use the first data row as the column headers of the destination table.

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