0

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
6
Views
7 Years
Discussion Span
Last Post by denniskhor
0

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?

0

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."}
0

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

0

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?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.