Missing Microsoft Excel as option in SQL Server data import tool

sql-server-2012 64-bit excel-2007 import-from-excel windows-server-2012-r2
Flo picture Flo · May 20, 2015 · Viewed 11.1k times · Source

I'm running SQL Server 2012 on a 64bit Windows Server 2012 R2.
I don't have MS Office installed.
I now notice that when I start Start->Program Files->Microsoft SQL Server 2012->Import and Export Data (64-bit) the MS Excel file option is missing from the datasource dropdown. How can I get that option without having to install Excel or Office on my server?

Answer

Flo picture Flo · May 21, 2015

Had to install this driver: https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

After that it works :)

Related questions

How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More
Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table, I've had a look through the forum but can't see how. I've looked the the properties but can't see an option, I have seen an answer …

Read More
Convert Date format into DD/MMM/YYYY format in SQL Server

I have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/jun/2013. How can I convert it for SQL server?

Read More