sql server connect: Linked to Excel - data changed on export -- sql server connect

Linked to Excel - data changed on export

eric db
3/29/2005 9:33:02 AM

sql server connect: Hi Group:

Hope this is the right forum...

Occasionally, when I write data to a linked Excel file from a varchar(50)
field, it arrives with a preceding single apostrophe (') in Excel. Doesn't
seem to have the tick in SQL when I view in QA. Any ideas why this would be,
or how I can avoid that?

Thanks!

RE: Linked to Excel - data changed on export

Cathy Boehm
3/29/2005 2:41:04 PM

Eric,
The apostrophe has to do with the leading zeros in you data, in Excel (and I
believe in 2003 version, it's no longer happening), Excel treats the values
in order not to lose them, thus puts the apostrophe in front. You want to
make sure that the Excel column is formatted for the data type you wanted to
be formatted before pouring the data in.
Hopefully, it helped.

[quoted text, click to view]

Re: Linked to Excel - data changed on export

Simon Worth
3/30/2005 12:09:49 PM

Excel does this to indicate the cell value should be treated as text -
but what you've passed in is probably convertible to an int or
something, so Excel explicitly states it's text by adding the (')

Simon Worth

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.