Problem changing field names

[Duane]

I have a table that consists of 12 fields that are named
M1 through M12 respectively. I would like to run a query
or macro that changes the field names in the table to
January through December respectively. My other problem is
this: Each month, I receive new data and the data in the
M1 field is the current month. Simply, the data I receive
each month is a rolling 12 months, so the query or macro
needs to assign M1 to the current month and M2 through M12
the months that preceded the current month. Any thoughts?

Thanks in advance for your help.

 

[Guest]

Here is my current process. First, I receive the flat
file, then I import it into Access. The date fields are
named M1-M12.

Using a make-table query, or possibly a macro, I would
like to rename the fields to the current month for M12,
previous month for M11, and so on.

Is there any way I can change these field names without
having to do it manually?