Single Quote Problem in Excel to Export

Hi,
We have to export our data in sql server table to any excel sheet. We have a
template to export, using oledb we are inserting rows to this template and
generating the excel output.
The problem here is we are getting a single quote extra in front of each
cell. can anyone help us in clearing this kind of an issue.
we tried sending some static strings to some columns on for taking from sql
server eventhen we are getting the same
Its Urgent, Please reply ASAP,
Pra Dannaniwe'd need to see the ASP.NET (VB?) code most likely...
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com
"Pra Dannani" wrote:

> Hi,
> We have to export our data in sql server table to any excel sheet. We have
a
> template to export, using oledb we are inserting rows to this template and
> generating the excel output.
> The problem here is we are getting a single quote extra in front of each
> cell. can anyone help us in clearing this kind of an issue.
> we tried sending some static strings to some columns on for taking from sq
l
> server eventhen we are getting the same
>
> Its Urgent, Please reply ASAP,
> Pra Dannani
>
>
Its C# Code. copy template to some folder and then read it by using oledb
with parameters nothing else.
"Curt_C [MVP]" <software_at_darkfalz.com> wrote in message
news:7741284C-1646-4C81-97C5-1F65678855D9@.microsoft.com...
> we'd need to see the ASP.NET (VB?) code most likely...
> --
> Curt Christianson
> site: http://www.darkfalz.com
> blog: http://blog.darkfalz.com
>
> "Pra Dannani" wrote:
>
have a
and
sql
We tried all possible combinations and finally able to find that the problem
is there in the excel template i specified the cells format type to text
then it worked properly.
"Pra Dannani" <pra@.pennywise.com> wrote in message
news:e%239V94l2FHA.3272@.TK2MSFTNGP09.phx.gbl...
> Its C# Code. copy template to some folder and then read it by using oledb
> with parameters nothing else.
> "Curt_C [MVP]" <software_at_darkfalz.com> wrote in message
> news:7741284C-1646-4C81-97C5-1F65678855D9@.microsoft.com...
> have a
> and
each
from
> sql
>
On Wed, 26 Oct 2005 23:02:45 +0530, "Pra Dannani" <pra@.pennywise.com>
wrote:
Hi,
We have to export our data in sql server table to any excel sheet. We have
a
template to export, using oledb we are inserting rows to this template and
generating the excel output.
The problem here is we are getting a single quote extra in front of each
cell. can anyone help us in clearing this kind of an issue.
we tried sending some static strings to some columns on for taking from sq
l
server eventhen we are getting the same
This is normal behavior from the Excel ISAM driver when it has to determine
the data type of the
source. As you've determined, it isn't an issue if the columns in the destin
ation Excel Worksheet
are defined prior to the export.
Paul
~~~~
Microsoft MVP (Visual Basic)