英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论