导入Excel文件到SQL Server时出错。

huangapple go评论116阅读模式
英文:

Error while trying to import an Excel file into SQL Server

问题

我使用 SQL Server 2022 Express 和 SQL Server Management Studio。

我尝试将一个 Excel 文件导入我创建的数据库。我右键单击其名称 => 任务 => 导入数据。然后有一个窗口打开了一秒钟然后关闭了。

我尝试点击 SQL Server 的 "导入和导出",但我收到以下错误信息:

标题:SQL Server 导入和导出向导

发生了 SQL Server Integration Services 向导无法处理的错误。

附加信息:

无法加载文件或程序集 'Microsoft.DataTransformationServices.ScaleHelper, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' 或其依赖项之一。系统找不到指定的文件。 (DTSWizard)

当我点击导入标志时,它可以工作,但不适合我。

英文:

I use SQL Server 2022 Express, and SQL Server Management Studio.

I'm trying to import an Excel file into a database I created. I click on its name with the right button => task => import data. Then a window opened for me for a second and closed.

I tried to click on SQL Server "Import and Export", and I get the error:

> TITLE: SQL Server Import and Export Wizard
>
> An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
>
> ADDITIONAL INFORMATION:
>
> Could not load file or assembly 'Microsoft.DataTransformationServices.ScaleHelper, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (DTSWizard)

When I click on import flag, it works but it doesn't suit me

答案1

得分: 1

使用 Xls 替代 Xlsx,将您的 Excel 文件保存为 Excel 1997-2003,可能会解决该问题。

英文:

use Xls instead of Xlsx,save your excel file as Excel 1997-2003, it might solve the issue.

huangapple
  • 本文由 发表于 2023年6月19日 13:42:21
  • 转载请务必保留本文链接:https://go.coder-hub.com/76503884.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定