How to make-table query to make a certain field a memo field instead of a text field? The reason I cannot use the text field is the limitation is 255 characters while I require 2000 characters?

I require 2000 characters?The first thing I would say to this is: Why do you require 2000 characters?? Is that necessary? Can you give any more information here?

Yes 2000 characters are necessary as this field will contain the data about description which are more than 255 characters and some are almost 2000 characters.......

Is there a reason why you can't create the table and then just use a delete query and append new data to the table when you need to? It will also help with database bloat as it won't be using temporary objects that don't go away until compacted.

Is there a reason why you can't create the table and then just use a delete query and append new data to the table when you need to?Either that (if it's feasible), or, I suppose you could write a procedure that creates the memo field, copies the data over, and then deletes the old field (hopefully, this is only a one time occurrance!).

Another possibility too, if you happen to be using A2007, is to use the attachment data type, and store those large descriptions in other files, which can be accessed through the individual records.