将Excel数据导入SQL数据库 [英] Importing Excel data to SQL database

问题描述

我正在使用SQL Server导入和导出向导.我已完成所有设置，并修改了映射以适应数据.无论我进行了什么修改，我都会继续收到错误0xc020901c:数据流任务:存在 输出列任务"错误(24)在输出"Excel Source Output"上； (9).返回的列状态为:文本被截断或目标代码页中的一个或多个字符不匹配.".
(SQL Server导入和导出向导)"

I am using the SQL Server Import and Export Wizard.  I have set up everything and have modified the mappings to accomodate the data.  No matter what modifications I make I continue to get  "Error 0xc020901c: Data Flow Task: There was an error with output column "Task" (24) on output "Excel Source Output" (9). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)"

任务被映射为nvarchar(max).但是看来问题出在Excel方面.

Task is a mapped as an nvarchar(max).  But it appears that the problem is on the Excel side.

您能建议我需要做什么来解决此问题吗?

Can you advise what I need to do to fix this?

提前谢谢您！

凯文

推荐答案

Hello Kevin，

 

谢谢您的发帖！  ;建议您将您的问题发布到一个MS论坛中，

SQL Server > SQL Server论坛

SQL Server > SQL Server Forums

这篇关于将Excel数据导入SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！