Set column order in a table before export

[blongmire]

How can I re-order a table to ensure the columns are in a set order before exporting? I need to make sure no columns are hidden and then re-sort to the order they are in the design view, or I can take the time to specify the column order directly -- either way would be fine.

I am comfortable with VBA or the macro builder, but I can't seem to find a way to make this happen.

Thanks!

 

[Joe4]

You would use a Query to sort your records the way that you like.
Then export the query.

 

[blongmire]

Thank you! Now that you say that, it's a perfectly obvious solution and I feel pretty stupid for not thinking of that. Thank you for the help!