Re: Remove apostrophe from text (export to 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)
);

How are you exporting it using ADO?

Stephen Howe


.