Re: Remove apostrophe from text (export to Excel)

This is for numeric values, i have trouble with text.


"Dave Patrick" <DSPatrick@xxxxxxxxxxxxxxxx> schreef in bericht
news:uKAqUfTbGHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
This article may help.

http://support.microsoft.com/default.aspx?scid=kb;[LN];823222

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Edwin Knoppert" wrote:
|I have trouble exporting data to an Excel ***.
| The *** is filled and all seems ok except the ordinary string data.
| They all get an apostrophe (')
|
| Like: 'MyName instead of MyName
| It's only visible when i select the cell and if i edit the cell, this
symbol
| remains.
| It's not visible in Open Office.
|
| I'm using VWD ASP.NET v2.
|
| Part of my create table statement:
| CREATE TABLE [sheet1] (
| [ID] NUMERIC
| , [Voorletters] varchar(255)
| );
|
| The data IS inserted using double quotes, previoulsy it was added using
| apostrophes but doesn not seem related.
|
| Thanks!
|
|




.