Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Append query from Temp Table

Discussion in 'Information Technology' started by Allan Skyner, Jul 28, 2006.

  1. Allan Skyner

    Allan Skyner
    Expand Collapse
    Guest

    Hi, I am importing data from Excel spreadsheet to a temp table which has one
    field set as a memo field as there is a large amount of data in one cell of
    my spreadsheet.
    I then run an append query to insert new records into another table which
    includes a memo field for the data in the memo field of the temp table,
    however not all the data is imported to the new memo field instead it simply
    cuts off at one point.

    Can anyone help?
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Allan

    Is all the data in the field of your temp table?

    Are you sure the final destination field is a Memo, not Text?

    What is the length where the string is being cut off? Is it consistent? Is
    it 255?

    Can you post the SQL code of your append query?

    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Allan Skyner" <AllanSkyner@discussions.microsoft.com> wrote in message
    news:0A11ADE7-89BC-47AE-B0BD-9C87529241BE@microsoft.com...
    > Hi, I am importing data from Excel spreadsheet to a temp table which has
    > one
    > field set as a memo field as there is a large amount of data in one cell
    > of
    > my spreadsheet.
    > I then run an append query to insert new records into another table which
    > includes a memo field for the data in the memo field of the temp table,
    > however not all the data is imported to the new memo field instead it
    > simply
    > cuts off at one point.
    >
    > Can anyone help?
     

Share This Page