Change Memo data type to Text data type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 26 Jan 2005 16:34 GMT

A table within the data warehouse that I get my data from, contains a
field I need to use in "memo" data type. I need to use some of the
data from this table to make another local table.
Performing the make-table query is no problem. But when I go to use
the field, "Course Result", I get a bunch of gibberish. I know that by
changing the memo data type to text could cause truncation, but that is
not a problem in this case.
I know that I can manually go into the table that I create and change
the data type, but I need to be able to do it - if possible - during
the make-table process. Obviously, I cannot change the data type in
the data warehouse.
Is there a way that I can cause the memo data type to convert to text
when I perform the make-table query?
Any help is greatly appreciated!

Thanks!

Reply to this Message

Ken Snell [MVP] - 26 Jan 2005 16:56 GMT

The gibberish may be because you have Unicode Compression turned on for the
memo field.

However, if you're always going to need the table that you're making now
each time, why not just keep a permanent, *empty* copy of that table and
make the specific field a text data type in that table. Then, instead of
using a maketable query, use an append query to copy the data to the
permanent table. Run a delete query before you run the append query so that
you start with an empty table each time. After you're all done with the
data, you could run a delete query as the last step to empty that table for
the next time.

Signature

Ken Snell
<MS ACCESS MVP>

>A table within the data warehouse that I get my data from, contains a
> field I need to use in "memo" data type. I need to use some of the
[quoted text clipped - 12 lines]
>
> Thanks!

Reply to this Message