Memos or Comments in Excel

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


Thank you for any anticipated help.

I am using Excel 2007. I am an Access developer. Sometimes I have clients
that want to keep notes (memos) on things in a database. Maybe they are in
disparate locations, so the question becomes how to do it easily. They could
use Access but when people are spread out geographically, this has its
problems. It occurred to me, however, that using a spreadsheet might be an
option along with Office Live.

Unlike Access, an Excel spreadsheet is easily accessible in Office Live.
But I am not sure how (if) Excel (Excel 2007) deals with fields that have the
potential to be long. Longer than 255 characters. In Access it's thought of
as a memo field. Don't know how it's thought of or referred to in Excel.

I have a couple of questions. The first is, how long can a comment be?

Second. Does Excel support anything like an Accees Memo field where the
memo can be as long as needed and also have formatting with line breaks and
bolding etc.

Third: Does anyone know of a web site or white paper that may give me more
inforamtion?

Thank you again for your help.
.

Relevant Pages

  • RE: Memos or Comments in Excel
    ... Excel doesn't have a specific Memo type. ... A cell can be set to type "Text" ...
    (microsoft.public.excel.misc)
  • Re: Export to excel has character limit
    ... <MS ACCESS MVP> ... When I try to export a query with a memo field to an excel (2007 or even ...
    (microsoft.public.access.queries)
  • Re: Import Errors Table, unparsable record
    ... > Excel table can easily exceed this. ... > using memo fields for the wider Excel columns of text, ... > hidden columns, and if there are formulas try getting rid of them by ... > Another post suggested this may be due to character limits per record. ...
    (microsoft.public.access.externaldata)
  • Re: ADODB is unable to copy more than 255 chars in excel cell
    ... > In the connection string you can set the extended property ... > That's the only way ADO/JET can READ excel cells beyond the 255 chars. ... The trick is to type the Excel table as MEMO e.g. ... convert values between data types but provides no effective mapping ...
    (microsoft.public.excel.programming)
  • RE: MS Access and Export to Excel
    ... You cannot do formatting of a memo field when exporting to Excel. ... have to either do the formatting in the spreadsheet or use automation to open ...
    (microsoft.public.access.externaldata)