Re: ADO/C++/EXCEL



I have followed the instructions contained in KB that you suggested.
Jet components in my PC are ok.
Please notice that on my PC is installed an office 97 updated to 2000
premium (I mean that 2k premium is not a fully installation but update
ver).
Also notice that if I omit HDR=yes software works properly ( but I
need to specify that 1st row contains the columns name otherwise all
cells in the calc *** will be setted to string type.).




On 27 Feb, 12:33, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
Damu wrote:
Hi, I am working on data import/export from oracle to access/excel.
When I insert "HDR=Yes" in the conn string an exception occoured:
"Can't find ISAM..."

My conn string is like this:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\tmp\test.xls;Extended
Properties="excel8.0;HDR=Yes";Persist Security Info=False

thanks

You probably need to install the Jet components which are available on the
microsoft site - I don't have a link handy so just do a search ... Look
here:http://support.microsoft.com/default.aspx/kb/283881

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

.