Results 1 to 2 of 2

Thread: appears from Access Database import

  1. #1
    Rosanne Guest

    appears from Access Database import


    When I import data from MS Access databases, some fields appear as
    &#34;<Long Text>&#34; in SQL. I cannot edit these fields in SQL. I have to export
    the table to Access, update the field, and then import again.

    There&#39;s got to be an easier way. What am I missing here?

    The field in Access is of type &#39;memo&#39;.

  2. #2
    Ananth Guest

    appears from Access Database import (reply)

    Memo datatypes are probably converted to Text datatype in SQL. In order to manipulate text, you need to use the functions READTEXT, WRITETEXT etc. See Books on Line.



    ------------
    Rosanne at 5/15/01 12:35:49 PM


    When I import data from MS Access databases, some fields appear as
    &#34;<Long Text>&#34; in SQL. I cannot edit these fields in SQL. I have to export
    the table to Access, update the field, and then import again.

    There&#39;s got to be an easier way. What am I missing here?

    The field in Access is of type &#39;memo&#39;.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •