I have a table that contains data fields that I need to translate into a new table or tables. Not all fields are used but for those that I copy into the new table they need to align with field positions from the original table.

Do I do a "Make Table" Query?

Originating Table:

FirstName MI LastName MemberNbr SeqNbr Addr1 Addr2 City State Zip DOB M1FName M1LName M1DOB M1SeqNbr etc...

New Table:

M1FName (MI Null Field) M1LName MemberNbr M1SeqNbr (Addr1 Null Field) (Addr2 Null Field) (City Null Field) (State Null Field) (Zip Null Field) M1DOB

How can I get originating fields into the correct alignment in the new (Target) table?

Guidance is much appreciated!!

Steve
Newark, DE