从Excel工作表中读取数据并插入到SQL Server中 [英] Read Data from excel sheets and insert into sql server

问题描述

你好，

我想从.xls文件中的不同工作表中读取数据.我还需要对照同一文件中的其他工作表来验证此数据.
然后，我需要将一些数据存储在veriables中，并相应地生成更多数据.

在asp.net中编程时，我从未使用过.xls.请指导我.

(我正在使用asp.net 3.5)

提前谢谢..

Hello,

I want to read data from different worksheets in a .xls file. I also need to verify this data against other worksheets in same file.
Then i need to store some of the data in veriables and generate some more data accordingly.

I have never worked with .xls while programming in asp.net. Please guide me..

(I am using asp.net 3.5)

Thanks in advance..

推荐答案

检查这些链接..

从excel中读取数据 [ http://www.spreadsheetgear.com/support/samples/excel.aspx [ ^ ]

check these links..

Read Data from excel[^]

http://www.spreadsheetgear.com/support/samples/excel.aspx[^]

请参阅此链接可能会帮助您...
[ ]
http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx [ ^ ]

Refer this link it may help you...
[]
http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx[^]

这篇关于从Excel工作表中读取数据并插入到SQL Server中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！