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

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.
 
D

Douglas J. Steele

I don't believe you can.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query Truncating Memo Field at 255 Characters 1
Can rich text format (memo) carry over in a make table query? 1
appending more than 255 characters into a Memo field 7
Changing Data Type of Column in Query. 1
Make Table Query changes Data Type 2
How can I convert text field to memo field in a query 10
Union query changes Memo to Text (256 char limit) 1
Linked table column type changes from text to memo 1

Top