如何将数据从excel导入到sql [英] How to Import data from excel to sql

问题描述

您好，



我将数据从excel导入到sql。

我使用以下连接字符串： -



excelconnectionstring = @Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ filepath +; Extended Properties ='Excel 8.0; HDR = {1}' ;



在excel中，一个coloum数据采用以下形式： -

WB / 7225 / X-123433



问题是，当我从excel获取数据到datatable时，所有数据都在数据表中，除了上面的表格..请告诉我如何纠正问题..

Hello,

I am importing data from excel to sql.
I am using the following connection string:-

excelconnectionstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR={1}'";

And in excel one coloum-data is in following form:-
WB/7225/X-123433

The problem is,when iam getting the data from excel to datatable,all data are coming in the datatable except the above form..please, tell me how can i correct the issue..

推荐答案

访问以下链接。希望其中一人可以帮助你。



http://cleancode4devs.blogspot.in/2012/01/import-data-from-excel-to-sqlserver.html [ ^ ]

< a href =http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/> http://www.mssqltips.com/sqlservertutorial/203/简单导入数据到sql-server / [ ^ ]

将数据从Excel导入到SQL Server [ ^ ]

Visit below links. Hope one of them may help you.

http://cleancode4devs.blogspot.in/2012/01/import-data-from-excel-to-sqlserver.html[^]
http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/[^]
Import Data from Excel to SQL Server[^]

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