Field Size and Data Type in Query (1 Viewer)

[cfmiles]

Is there a way to define the Field Size and Data Type in the query when performing a Make Table?

I've tried Setting the field size and data type in an "existing" table and then use an append query to fill it, however, I receive a validation rule error.

I can make the table and then change the field size and data types for all of the fields without losing any data....
>>>>>> I need to give this file to someone every month, so a more automated way would be much appreciated!

Thanks in advance for any help!

 

[Liv Manto]

You can create a table using vba code.
You could set the field type, size etc.

 

[Pat Hartman]

The validation rule you're probably running afoul of is the one associated with the "allow zero length" property. The default for this property is no. If your data may contain zero length strings, set the property to yes.

 

[cfmiles]

Thanks to both of you for the suggestions. The Allow Zero Length "Yes" was the best solution for what I was doing. Thanks so much for the response!