Microsoft SQL Server 2017导入导出向导 [英] Microsoft SQL Server 2017 Import Export Wizard

问题描述

我正在使用SQL Server管理工作室2017

想使用< g class将数据从excel导入到表中=" gr_ gr_233 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep"数据-GR-ID =" 233" ID = QUOT; 233"> SQL< / g取代;导入导出
向导。报告的错误是Microsoft ACE OLEDB.16.0提供程序未在本地计算机上注册。

I安装Microsoft Access数据库引擎2016 64位但仍然得到相同的错误。

我的公司支持64位，还< g class =" gr_ gr_216 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace"数据-GR-ID =" 216" ID = QUOT; 216"> SQL< / g取代; server 2017does< g class =" gr_
gr_246 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace"数据-GR-ID =" 246" ID = QUOT; 246">（NOT）LT / g取代;带有64位SQL向导< g class =" gr_ gr_318 gr-alert gr_spell gr_inline_cards gr_run_anim
ContextualSpelling ins-del multiReplace"数据-GR-ID =" 318" id =" 318"> import export< / g>。

尝试安装32位和64位ACE，但无效。 

我希望Microsoft支持解决此问题。

谢谢

解决方案

你好shivangimgupta，

 

依据根据您的描述，您希望通过SQL Server导入和导出向导将数据从Excel导入SQL Server。您已安装Microsoft Access数据库引擎2016但仍然
得到错误。

 

根据我的测试，当我选择"时，我会得到同样的错误" ; Microsoft Excel 2016"作为Excel版本。

 

 

但是，当我选择"Microsoft Excel 2007-2010"时，我可以成功导入数据。作为Excel版本。您可以尝试选择"Microsoft Excel 2007-2010"吗？在
列表框中。

 

 

 

最好的问候，

艾米丽

I am using  SQL server management studio 2017

Would like to import data from excel to the table using <g class="gr_ gr_233 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" data-gr-id="233" id="233">SQL</g> import export wizard. Error reported is  Microsoft ACE OLEDB.16.0 provider is not registered on the local machine.

I installed Microsoft Access database engine 2016 64 bit but still getting the same error.

My company supports 64 bit, also <g class="gr_ gr_216 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="216" id="216">sql</g> server 2017does<g class="gr_ gr_246 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="246" id="246">n’t</g> come with 64-bit SQL wizard <g class="gr_ gr_318 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="318" id="318">import export</g>.

Tried installing 32 and 64 bit ACE but didn't work. 

I would like Microsoft support to resolve this.

Thanks

解决方案

Hi shivangimgupta,

 

According to your description, you want to import data from excel to SQL Server via SQL Server import and export wizard. You have installed the Microsoft Access database engine 2016 but you still get the error.

 

Based on my test, I will get the same error when I choose the "Microsoft Excel 2016" as the Excel version.

 

 

However, I can import the data successfully when I choose the "Microsoft Excel 2007-2010" as the Excel version. Could you please try to select the "Microsoft Excel 2007-2010" in the list-down box.

 

 

 

Best Regards,

Emily

这篇关于Microsoft SQL Server 2017导入导出向导的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！