asp如何访问Excel表？

答案：
看看下面：
<%@ Page Language="VB" %> 
<%@ Import Namespace="System.Data" %> 
<%@ Import Namespace="System.Data.ADO" %> 
<script language="VB" runat="server"> 
Sub Page_Load(sender As Object, e As EventArgs) 
Dim myDataset As New DataSet() 
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ 
& "Data Source=C:\intels\exceltest.xls;" _ 
& "Extended Properties=""Excel 8.0;""" 
Dim myADODataSetCommand As New ADODataSetCommand("SELECT * FROM [Sheet1$]", strConn) 
myADODataSetCommand.TableMappings.Add("Table", "ExcelTest") 
myADODataSetCommand.FillDataSet(myDataset) 
DataGrid1.DataSource = myDataset.Tables(0).DefaultView 
DataGrid1.DataBind() 
End Sub 
</script> 
<p><asp:Label id=Label1 runat="server">Excel表格内容</asp:Label></p> 
<asp:DataGrid id=DataGrid1 runat="server"/>

上一个：更快更好地调试ASP程序代码？
下一个：Asp简单日历控制程序？