The latest version of Microsoft Access Database Engine can open the earlier version of Excel, so make sure that you have the latest one.
The Microsoft Access Database Engine 2016 Redistributable comes with two versions: Now, when Microsoft Access Database Engine 2016 Redistributable is installed, we should see the Microsoft Excel provider in the list, but unfortunately the Microsoft Excel provider does not show in the list of the Data source drop down box.
If ‘Business Entity’ is not a local object, check your network connection or contact the server administrator.
(Microsoft Access Database Engine) If the Copy data from one or more tables or views radio button is chosen, when the Next button is pressed, the Select Source Tables and Views page will be shown: On this page, all worksheets for the Excel file (Import Data.xlsx) will be listed under the Source column.
In our case, that is the Microsoft Excel 2016 version: The latest option on this page is the First row has column names check box: By default, this option is checked.
It treads the first rows of the data source as the column names: But if this option is enabled and data source does not contain column names, the SQL Server Import and Export Wizard will add the column names, starting with the name F1 for the first column name: If this option is disabled and data source contain the column names the SQL Server Import and Export Wizard treats these columns as the first row of data: Now, when everything is set on the Choose a Data Source page of the SQL Server Import and Export Wizard, click the Next button to continue.
For further details on cookies, please see our cookies policy.
In this article, steps for importing data from an Excel file to a SQL Server database will be explained using the SQL Server Import and Export Wizard including some of problems that can occur during the processes.
For example, the Access Database is installed and the SQL Server Import and Export Wizard 64-bit version is launched.
If the Write a query to specify the data to transfer is chosen, then only data that are specified in a SQL query will be copied from an Excel worksheet to a destination SQL Server database.
If the Write a query to specify the data to transfer in the Choose a Destination page is chosen, then the Provide a Source Query page will be shown when the Next button is pressed: In the SQL statement text box, type the query that will select the data to copy form the Excel file to the SQL Server database or load a query using the Browse button.
In this case, in order to see the Microsoft Excel provider in the list of the Data source drop down box, launch the SQL Server Import and Export Wizard 32-bit version and the Microsoft Excel provider will appear in the list: Now, when all is installed, from the list, select the Microsoft Excel provider.
On the Choose a Data Source page, additional options appear: In the Excel file path box, type the location to the Excel file or use the Browse button to navigate to the location: From the Excel version drop down box, choose the version of Excel that uses the source workbook.