change data type

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top