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.

Recommended Answers

All 2 Replies

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.