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,
Prasad Dannaniwe'd need to see the ASP.NET (VB?) code most likely...

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

"Prasad 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 sql
> server eventhen we are getting the same
>
> Its Urgent, Please reply ASAP,
> Prasad 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
>
> "Prasad 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
sql
> > server eventhen we are getting the same
> > Its Urgent, Please reply ASAP,
> > Prasad Dannani
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.

"Prasad Dannani" <prasad@.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...
> > we'd need to see the ASP.NET (VB?) code most likely...
> > --
> > Curt Christianson
> > site: http://www.darkfalz.com
> > blog: http://blog.darkfalz.com
> > "Prasad 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
> sql
> > > server eventhen we are getting the same
> > > > > Its Urgent, Please reply ASAP,
> > > Prasad Dannani
> > >
On Wed, 26 Oct 2005 23:02:45 +0530, "Prasad Dannani" <prasad@.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 sql
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 destination Excel Worksheet
are defined prior to the export.

Paul
~~~~
Microsoft MVP (Visual Basic)