将Excel信息导入到SQL数据库 [英] Importing excel info to sql database

问题描述

我有一个应用程序，想将信息从excel文件移动到sql，但问题是结构/列不相同，有没有办法在读取时指定要转到哪一列?

Hi,

I have an application and want to move information from a excel file to sql but the problem is that the structure/columns are not identical, Is there a way to specify to which column to go to when reading it?

推荐答案

您好，

请参见下面的链接.可能会对您有所帮助.您还可以在此处映射列.所以也许您可以找到解决方案.

http://dotnetslackers.com/articles/sql/Importing- MS-Excel-data-to-SQL-Server-2008.aspx [

Hello,

Please see the below link. It might be help you. Here you can map the column as well. So may be you can find the solution.

http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx[^]

Thanks,
Viprat

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