且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

无法将我的.xlsx导出到我的Sql Server 2008数据库

更新时间:2023-02-07 08:31:00

转到Microsoft的网站并下载

Go to Microsoft's website and download Microsoft Access Database Engine 2010 Redistributable. Install that and import the following settings into the registry.

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\Providers\Microsoft.ACE.OLEDB.12.0]
    "AllowInProcess"=dword:00000001
    "DynamicParameters"=dword:00000001
    "DisallowAdhocAccess"=dword:00000000

我相信这应该可以让您导入电子表格.

I believe that should allow you to import your spreadsheet.