Missing Microsoft Excel as option in SQL Server data import tool

Question

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?

There is no 64-bit Excel driver for this, IIRC. You need to run the 32-bit Import & Export Wizard. — TylerH, Aug 25 '17 at 13:57

score 13 · Accepted Answer · answered May 21 '15 at 01:31

13

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

After that it works :)

answered May 21 '15 at 01:31

Adam

6,041
36
120
208

score 0 · Answer 2 · answered Dec 23 '20 at 07:50

0

I installed Microsoft Excel. It worked for me.

answered Dec 23 '20 at 07:50

p saisowjanya

1

Missing Microsoft Excel as option in SQL Server data import tool

2 Answers2

Linked