>Hi.
>Would anybody suggest the Dot Net alternative to the following:
>_____________________________________
>Sele 0
>Use MyTable
>Appe from MyExcelFile.xls type XLS
>_____________________________________
>
>Regards,
>Gerard
Gerard,
The steps are a little more involved in .NET, but the idea is to create an OleDbConnection using the Microsoft Jet provider to the XLS file. Once you have the connection, you can query it the same way as any other data source.
If found this connection string at
http://www.simongibson.com/intranet/adooledb/strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath(".\excel\myExcelFile.xls") & ";" & _
"Extended Properties=""Excel 8.0;HDR=Yes;"";"