Re: Remove apostrophe from text (export to Excel)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Edwin wrote on Tue, 2 May 2006 15:14:33 +0200:

I know but how to get rid of it?

Why exactly do you need to get rid of it? For Excel it defines the cell as
text rather than general, when using ADO to read that data it should not
appear. Appearing in the Edit field is purely to define the data - it does
not affect the spreadsheet itself.

Dan


.

Relevant Pages

  • Re: ADODB.Recordset from workbooks : numbers only?
    ... ADO is basically treating you Excel sheet as a table in a database. ... , formula and cell references have no meaning, only the result in each cell. ... Set rsData = New ADODB.Recordset ...
    (microsoft.public.excel.programming)
  • Re: cell is not empty but excel thinks it is,,,why?
    ... the tools to get rid of it. ... Somehow that space is a "0" and Excel thinks it is the only thing ... I have reformatted the cell to be numbers and not text, ... sum function on a column of numbers, excel says the sum is zero. ...
    (microsoft.public.excel.misc)
  • Re: Help - Updating a document
    ... right to the specific data in Access through ADO. ... In fact, using the same technology, you can even do that to Excel ... >to a degree, but it insert a single cell table, not the contents of the cell ... I saved my master as an excel file. ...
    (microsoft.public.word.docmanagement)
  • Re: Excell
    ... Sounds to me that you'd be better off connecting to the file using the Excel ... VBA object model if you need informaiton on the cell presentation properties ... >> ยค I assume this can be done using ADO? ...
    (microsoft.public.vb.database.ado)
  • populate Access numeric field with nothing
    ... i'm having an issue with pushing into Access DB numeric field empty ... value from Excel cell using ADO ...
    (microsoft.public.excel.programming)