How can I define table of an existed Excel file?

[ATC]

I have an existed Excel file (My_Excel.xls) with pure data, when I try to open it as database ... following SQL define requires a table name (what_table?) in order to access it: conn = "Provider= Microsoft.Jet.OLEDB.4.0; Data Source=" & Environment.CurrentDirectory & "\My_Excel.xls; Extended Properties=Excel 8.0;" Dim SQLString As String = "SELECT * FROM what_table" DBCon = New OleDbConnection(conn) DBDat = New OleDbDataAdapter(SQLString, DBCon) DBCom = New OleDbCommandBuilder(DBDat) DatT = New DataTable DBCon.Open() DBDat.Fill(DatT) DBCon.Close() How can I define My_Excel.xls the table "what_table" in order to use the above code? :doh: Thanks to any help

[pmarfleet]

Define a named range in your spreadsheet called what_table that represents the data area you want to access.

Paul Marfleet

[ATC]

It is working. Thanks :rolleyes:

[pmarfleet]

Good stuff.

Paul Marfleet