import and export wizard - data source - there is missing option excel

Question

Im trying to import data from excel to Microsoft sql manager studio. Im using import and export wizard. When I want to choose data source, there is no excel. What can I do to have also an option excel? Thanks

Well, I ve found that there is an option flat file source (.txt). So I can use it instead of excel. But still Im interested about adding excel as a type of source, if anybody has some ideas. Thanks. — kvietok, Nov 09 '16 at 18:38
I believe you have to have excel installed (either on the machine ssms is running or on the sql server machine itself, I forget which) in order to do this — DForck42, Nov 09 '16 at 19:38

score 1 · Answer 1 · edited May 23 '17 at 12:30

1

You need a provider for excel. On a workstation it should get installed with Excel. On a server there are a few options that are easily found with a web search. "SSIS Excel Provider"

Here is a post that references the topic Microsoft.ACE.OLEDB.12.0 is not registered

edited May 23 '17 at 12:30

Community

1
1

answered Nov 09 '16 at 20:06

Joe C

3,925
2
11
31

score 1 · Answer 2 · edited Mar 01 '22 at 09:03

1

You need to install this 64 bit driver: Driver

After that it should work.

edited Mar 01 '22 at 09:03

Glorfindel

21,988
13
81
109

answered Nov 09 '16 at 20:07

bwilliamson

391
1
13

import and export wizard - data source - there is missing option excel

2 Answers2