How to define field types in a make table

[accessmatt]

Hello,



Does anyone know how I can define all of my field types as text in a Make Table query? I want to overwrite the inherited type, which sometimes is a number.

SELECT [My Table].* INTO [My Table 2]
FROM [My Table];

Thanks

[ranman256]

if you want a string, CSTR([field])
CLNG([field]) ,long
CINT([field]), integer
...

[JoeM]

If the table structure and field formats are known ahead of time, what I like to do is create a blank table shell, where I have pre-defined all the fields and data types, and other rules or formats I may want. I then use an Append Query instead of a Make Table Query to write the data to this table structure.

If it is something I need to re-use, I just create a one-line macro to delete the existing data out of the table before each use, i.e.
choose the RunSQL Action, and use the code:

DELETE [MyTableName].* FROM [MyTableName];

[ranman256]

I would suggest NOT using make table, but rather an append query, to a table that already has the fields defined.