468,106 Members | 1,474 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,106 developers. It's quick & easy.

C# Create Excel sheet -> Could not find installable ISAM

I am using C# / ADO.NET to create an Excel sheet:

This connection string works:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" +
"Extended Properties=Excel 8.0;";

This connection string DOES NOT:
....
"Extended Properties=Excel 8.0;HDR=YES;";
=> Error: Could not find installable ISAM
Remark: I've tried ";HDR=YES;" and ";HDR=YES"

Honestly I do not understand how this is related?
Regards HW
Nov 15 '05 #1
2 14834
On 3 Jan 2004 11:39:04 -0800, un***@web.de (Horst Walter) wrote:

§ I am using C# / ADO.NET to create an Excel sheet:
§
§ This connection string works:
§ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" +
§ "Extended Properties=Excel 8.0;";
§
§ This connection string DOES NOT:
§ ...
§ "Extended Properties=Excel 8.0;HDR=YES;";
§ => Error: Could not find installable ISAM
§ Remark: I've tried ";HDR=YES;" and ";HDR=YES"
§

Tricky syntax as Hussein pointed out. Here is an example that I have used:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=d:\\My Documents\\Book2.xls;" +
"Extended Properties=" + (char)34 + "Excel 8.0;HDR=Yes;" + (char)34;
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 15 '05 #2
Try this:

http://www.kjmsolutions.com/datasetarray.htm

This will write the dataset to an array and then to an excel spreadsheet.

Also, solutions like these can be found by using the VB.NET/ADO.NET free
search engine tool at
http://www.kjmsolutions.com/newsgrouptool.htm

"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:fq********************************@4ax.com...
On 3 Jan 2004 11:39:04 -0800, un***@web.de (Horst Walter) wrote:

§ I am using C# / ADO.NET to create an Excel sheet:
§
§ This connection string works:
§ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" +
§ "Extended Properties=Excel 8.0;";
§
§ This connection string DOES NOT:
§ ...
§ "Extended Properties=Excel 8.0;HDR=YES;";
§ => Error: Could not find installable ISAM
§ Remark: I've tried ";HDR=YES;" and ";HDR=YES"
§

Tricky syntax as Hussein pointed out. Here is an example that I have used:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=d:\\My Documents\\Book2.xls;" +
"Extended Properties=" + (char)34 + "Excel 8.0;HDR=Yes;" + (char)34;
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

Nov 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by pmclinn | last post: by
reply views Thread by rajeshkothuru | last post: by
8 posts views Thread by yogarajan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.