943,147 Members | Top Members by Rank

Software Development > C# > How C# read Excel 4.0 with MS SQL?
Ad:
  • C# Discussion Thread
  • Unsolved
  • Views: 1511
  • C# RSS
Permalink
Jan 26th, 2010
0

How C# read Excel 4.0 with MS SQL?

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

C# Syntax (Toggle Plain Text)
  1. using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"" + fileName + "\";Extended Properties=Excel 8.0;"))
Similar Threads
Reputation Points: 6
Solved Threads: 0
Junior Poster in Training
denniskhor is offline Offline
72 posts
since Oct 2007
Moderator
Reputation Points: 2136
Solved Threads: 1228
Posting Genius
adatapost is offline Offline
6,525 posts
since Oct 2008
Permalink
Jan 26th, 2010
0
Re: How C# read Excel 4.0 with MS SQL?
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

>>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?
Featured Poster
Reputation Points: 1749
Solved Threads: 735
Senior Poster
sknake is offline Offline
3,948 posts
since Feb 2009
Permalink
Jan 26th, 2010
0
Re: How C# read Excel 4.0 with MS SQL?
Click to Expand / Collapse  Quote originally posted by 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

>>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:

C# Syntax (Toggle Plain Text)
  1. {"External table is not in the expected format."}
Reputation Points: 6
Solved Threads: 0
Junior Poster in Training
denniskhor is offline Offline
72 posts
since Oct 2007
Permalink
Jan 26th, 2010
0
Re: How C# read Excel 4.0 with MS SQL?
Can you upload the Excel file in question? Click "Go Advanced" then "Manage Attachments" and upload a .ZIP file containing the spreadsheet.
Featured Poster
Reputation Points: 1749
Solved Threads: 735
Senior Poster
sknake is offline Offline
3,948 posts
since Feb 2009
Permalink
Jan 27th, 2010
0
Re: How C# read Excel 4.0 with MS SQL?
Click to Expand / Collapse  Quote originally posted by denniskhor ...
Ya, its throw an exception which state:

C# Syntax (Toggle Plain Text)
  1. {"External table is not in the expected format."}

I dunno use that ODBCconnection string method.. who can teach me?
Reputation Points: 6
Solved Threads: 0
Junior Poster in Training
denniskhor is offline Offline
72 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in C# Forum Timeline: how to show certain files according to extention ?????
Next Thread in C# Forum Timeline: Loading Icon from Resources??


Tags
excel_interop



About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC