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

[Horst Walter]

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

[Paul Clement]

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)

[scorpion53061]

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)