エクセルデータを読んじゃう。
DATASはシート名ね。
さらにファイルにはASPNETさんの読み取り可能な権限を付加してあげてくださいね。
Sub Page_Load(Sender As Object, E As EventArgs) ' TODO: ConnectionStringとCommandTextの値を調整してください Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" + _ "Data Source=%mydbq%;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" Dim CommandText As String = "SELECT * FROM [DATAS$]" ConnectionString=replace(ConnectionString,"%mydbq%","c:\コピーmyfile.XLS") Dim myConnection As New System.Data.OleDb.oledbConnection(ConnectionString) Dim myCommand As New System.Data.OleDb.oledbCommand(CommandText, myConnection) myConnection.Open() DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection) DataGrid1.DataBind() End Sub