Remove apostrophe from text (export to Excel)
- From: "Edwin Knoppert" <news@xxxxxxxxxxxxxx>
- Date: Mon, 1 May 2006 17:46:53 +0200
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!
.
- Follow-Ups:
- Re: Remove apostrophe from text (export to Excel)
- From: Daniel Crichton
- Re: Remove apostrophe from text (export to Excel)
- From: Stephen Howe
- Re: Remove apostrophe from text (export to Excel)
- From: Dave Patrick
- Re: Remove apostrophe from text (export to Excel)
- Prev by Date: RE: Field.GetChunk() doesn't differentiate between NULL and empty ntex
- Next by Date: Re: Remove apostrophe from text (export to Excel)
- Previous by thread: RE: Field.GetChunk() doesn't differentiate between NULL and empty ntex
- Next by thread: Re: Remove apostrophe from text (export to Excel)
- Index(es):