read excel files

  • Thread starter Thread starter Guest
  • Start date Start date
freddy said:
I do not want to automate, I just want to readthe data from excel

You can open and query an Excel Spreadsheet using the JET OLE DB Provider:
http://www.able-consulting.com/MDAC...oviders.htm#OLEDBProviderForMicrosoftJetExcel
http://support.microsoft.com/?id=278973 (ADO-classic, but this doesn't
have an effect on connStrings and query syntax)

A C#-Example is here:
Query an Excel Worksheet Without using Interop
http://www.knowdotnet.com/articles/exceldatasource.html

Cheers

Arne Janning
 
Back
Top