Memo fields in Make table query

[richardn]

I have to run a SQL Statement (make table query)from code that creates a table, and sometimes one of the fields in memo type. in this case I get an error:
"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data"
How can I control the fields types when I am using make table queries?
Using: WinXP and OfficeXP
Thanks,
Richard

 

[TessB]

I would create the table myself and specify the data types. Then, instead of doing a make table query, I would write a delete query and then an append query. (Deleting the records first, and then appending the new ones you need to make the table) Otherwise, I have no idea!

 

[richardn]

I tought about this solution, I hope there are other ways to do this.
Thanks for your help.
Richard