Force data type from Text to Memo in a simple Make Table Query

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I'm concatenating fields of various data types that upon completion sometimes
reaches around 500 characters. Not huge, but larger than the Text limitation
to which is what Access 2007 of course converts this. How can I force the
data type to be Memo while I'm in the query so the resulting table displays
all the data without any truncation.
 
I don't believe you can.

I think you'll have to create the table first, and then append to it.
 
Back
Top