How C# read Excel 4.0 with MS SQL?

[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;"))

[__avd]

Please refer the following links posted by sknake.

1. http://www.daniweb.com/forums/thread196171.html
2. http://www.daniweb.com/forums/thread202316.html
3. http://www.daniweb.com/forums/thread210409.html
4. http://www.daniweb.com/forums/thread210020.html
5. http://www.daniweb.com/forums/thread175798.html

[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?

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

[sknake]

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

[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?