change data type

[Guest]

I am using a make table query to create a table
I am looking for a way to specify in that process that one of the field should be of data type Memo
I can do that manualy after the creation of the table, but not interested in that
I am looking for a way to do it in the querry or by vba or macro
Many thanks to you all.

 

[[MVP] S.Clark]

You can make the table once, arrange it how it will be needed, then instead
of blowing it away with a Make-Table, you can use a Delete and an Append
Query instead. This will retain the structure, and prevent the need to
restructure every time.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-