Member Avatar for denniskhor

I tried below code... it's doesn't work as well... any got solution for this? Thanks.

using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"" + fileName + "\";Extended Properties=Excel 8.0;"))
  • 3 Contributors
  • 5 Replies
  • 581 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by denniskhor

Recommended Answers

All 5 Replies

Member Avatar for sknake

I don't think I have anything to add to this thread regarding Excel. Adatapost already linked to all of my knowledge for the product :P

>>I tried below code... it's doesn't work as well... any got solution for this? Thanks.

What do you mean by "doesnt work well"? Is it slow or throwing an exception?

Member Avatar for denniskhor

I don't think I have anything to add to this thread regarding Excel. Adatapost already linked to all of my knowledge for the product :P

>>I tried below code... it's doesn't work as well... any got solution for this? Thanks.

What do you mean by "doesnt work well"? Is it slow or throwing an exception?

Ya, its throw an exception which state:

{"External table is not in the expected format."}
Member Avatar for sknake

Can you upload the Excel file in question? Click "Go Advanced" then "Manage Attachments" and upload a .ZIP file containing the spreadsheet.

Member Avatar for denniskhor

Ya, its throw an exception which state:

{"External table is not in the expected format."}

I dunno use that ODBCconnection string method.. who can teach me?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.