Is there a way to specify a field type (short text) in a make table query. I have Googled and it appears that there is not so I was wondering if you could create the make table query, then view it in sql form and then add as string after that field.
When I try
SELECT AllRailcarData.RailcarID, AllRailcarData.CarInitials, AllRailcarData.CarNumber as string INTO TestFieldType
FROM AllRailcarData;
I get
The select statement includes a reserved word or argument name that is misspelled or missing, or the punctuation is incorrect.
The actual make table query is quite long and has a lot of fields so I don't want to have to rewrite in vba if I don't have to.