table predefined format

[sanjeewack]

I have a table format which is consistent. I bring data to Access and in the design view, I apply the format. This format never changes.

How can I skip this manual step?

How can I store a table (field name, data type) format and each time I have a new file apply this format?

I have imports and exports already assigned and if I can apply a file format at the same time, this process is full automated.

Thanks, Sanjeewa

[aytee111]

Keep an empty temp table and copy it each time - DoCmd.CopyObject