For example, the AccessDatabaseEngine.exe is installed and the SQL Server Import and Export Wizard 64-bit version is launched. This is because you may run a wrong version of the SQL Server Import and Export Wizard. 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. The Microsoft Access Database Engine 2016 Redistributable comes with two versions:ĪccessDatabaseEngine.exe is 32-bit versionĪccessDatabaseEngine_X64.exe is 64-bit version The latest version of Microsoft Access Database Engine can open the earlier version of Excel, so make sure that you have the latest one. To see the Microsoft Excel provider in the list, install Microsoft Access Database Engine 2016 Redistributable. But there is no need to install Microsoft Office (Microsoft Excel) in order to see the Microsoft Excel provider in the Data source drop down box list. The first reason could be that Microsoft Office isn’t installed. In our case, the provider for connecting to the Excel file is the Microsoft Excel provider.įrom the Data source drop down box, select the Microsoft Excel provider:Īs you can see, there is no Microsoft Excel provider in the list of the Data source drop down box. In the Choose a Data Source page, in order to continue with importing data from Excel to SQL Server the data source provider and way of connecting with data source must be provided. The next page in the SQL Server Import and Export Wizard is Choose a Data Source page: On this page, only a quick introduction of the SQL Server Import and Export Wizard is shown.Ĭlick the Next button to continue. The first page that appears when the SQL Server Import and Export Wizard launched is Welcome page: There are several ways to do that, and this can be seen on the How to import/export data to SQL Server using the SQL Server Import and Export Wizard page To start the process of importing data from an Excel file to a SQL Server database using the SQL Server Import and Export Wizard the SQL Server Import and Export Wizard needs to be launched. 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. The OPENROWSET and OPENDATASOURCE functions There are many ways to import data from an Excel file to a SQL Server database using:

How to convert excel to access table