read excel files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to read an excel file on the nework and load the data to some combobox.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top