Writing excel worksheet apostrophe coming through OLEDB problem

[sebastian3]

Hi all,
I have a issue in writing excel worksheet through OLEDB/Excel 8.0 provider where an apostrophe is coming in every cell before the value.
When the excel worksheet is created through provider,cells are not getting as Text format and remaining as General even though I have denoted it as Text column.
Same code is having no issue if the worksheet is already created and converted to Text manually. And also no issues using ACE.OLEDB/Excel 12.0 provider.
But I have to use OLEDB4.0/Excel 8.0 in server.Any input is highly appreciated.
Thanks in advance.

[kRod]

This may help>>>
http://www.google.com/#hl=en&sclient=psy-ab&q=microsoft.jet.oledb.4.0+apostrophe&oq=oledb+4.0+ap&aq=0mK&aqi=g-mK3&aql=&gs_l=hp.3.0.0i5i30l3.0.0.1.125.0.0.0.0.0.0.0.0..0.0...0.0.C-DPYOs_k5I&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=be92a6bf3be444e8&biw=1024&bih=600

[sebastian3]

Thanks for your help.
At last i learnt to google !