MS SQL Server Connectivity - Re: Linked to Excel

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Linked to Excel - data changed on export

Simon Worth

2005-03-30, 7:03 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

eric db wrote:
> 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!
>
> eric db

Sponsored Links