Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Missing Microsoft Excel as option in SQL Server data import tool

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?

like image 264
Adam Avatar asked May 20 '15 20:05

Adam


1 Answers

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

After that it works :)

like image 141
Adam Avatar answered Oct 17 '22 10:10

Adam