Excel File

  • Thread starter Thread starter Jim Heavey
  • Start date Start date
J

Jim Heavey

Does someone have an example of accessing an Excel spreadsheet using
ASO.Net?

Thanks in advance for your assistance!
 
Hi Jim,

Try using OleDbConnection with the connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FILENAME.xls;Extended
Properties=\"Excel 8.0; IMEX=1\";

The use a OleDbCommand with CommandText like:

SELECT * FROM [Sheet1$]

HTH,
 
You must log in or register to reply here.

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

Similar Threads

encrypt/decrypt function in asp.net 2 2
determinig datatype in excel 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Excel spreadsheets opening at top instead of bottom. 4
How to avoid script database hacking? 12
Access #Error & Excel Pivot 0
Excel How to Fix Damaged Excel File That Won't Open? 3
How do I invoice a cost to a custom built MS Access Accounting Database? 0

Back
Top