1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access 2000

Discussion in 'Business Applications' started by lynn_victoria12047, Dec 3, 2001.

Thread Status:
Not open for further replies.
Advertisement
  1. lynn_victoria12047

    lynn_victoria12047 Thread Starter

    Joined:
    Jan 15, 2001
    Messages:
    123
    In exporting a Access 2000 querie to Excel 2000, I have an Access field that is formatted as Memo, that Exel is truncating. Does anyone have an explanation, or a way to keep this from happening? Thanks :)
     
  2. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    Memo fields are more than 255 charachters long. I believe Excel will truncate after 255 charachters. I think that is correct, but I could be wrong. Looked in Help and saw :
    Column width 0 (zero) to 255 characters
     
  3. lynn_victoria12047

    lynn_victoria12047 Thread Starter

    Joined:
    Jan 15, 2001
    Messages:
    123
    Yes, While that is true, I can only find, txtparsefile to set column size when importing from a .txt file. How can I fix this to accept in the size of the Memo field from Access? Any other ideas?
     
  4. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    You can't! That is the way Excel was designed....I know you can physically insert or type more than 255 charachters by typing.
     
  5. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Well, in Access, you could first break up the memo field by doing an LEFT and MID in a make-table query that adds the necessary columns for the continuing text, and export THAT instead, no?

    I guess you'd have to find out the largest amount of characters first...
     
  6. downwitchyobadself

    downwitchyobadself

    Joined:
    Oct 13, 2000
    Messages:
    941
    From Excel help:

    How much of your memo field is making it in? Have you checked the formula bar for the cell(s) in question? You can copy the text, open the immediate window of Access (CTL+G), and type
    Code:
    ?Len("my copied text")
    to see how many characters you're getting. Where my copied text is what you got in Excel, of course. Don't forget the quotations around it.
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/60561

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice