Change Memo data type to Text data type

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

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!
 
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.
 
Back
Top