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.
--
Ken Snell
<MS ACCESS MVP>
"DS" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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!
>
|
Similar Threads
