从Excel工作表中读取数据并插入到SQL Server中

本文介绍了从Excel工作表中读取数据并插入到SQL Server中的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

你好， 我想从.xls文件中的不同工作表中读取数据.我还需要对照同一文件中的其他工作表来验证此数据. 然后，我需要将一些数据存储在veriables中，并相应地生成更多数据. 在asp中编程时，我从未使用过.xls.请指导我. (我正在使用asp 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. Please guide me.. (I am using asp 3.5) Thanks in advance..

推荐答案

检查这些链接.. 从excel中读取数据 [ ^ ] www.spreadsheetgear/support/samples/excel.aspx [ ^ ] check these links.. Read Data from excel[^] www.spreadsheetgear/support/samples/excel.aspx[^]

请参阅此链接可能会帮助您... [ ] www.sql-server-helper/tips/read-import-excel-file-p03.aspx [ ^ ] Refer this link it may help you... [] www.sql-server-helper/tips/read-import-excel-file-p03.aspx[^]