Use Macro or VB to change column title automatically

[morlasr]

Hi everyone,

I really need help with this, I'm a beginner with Access.



I'm making a db that will import a spreadsheet from Excel, then separate it into 3 different tables using queries, but then I need to put all the 3 different tables together one after the other. The problem is that the 3rd column on each table have different names on each table, so I can't append the tables together.

So, how can I use a Macro or something to change the column name on all 3 different tables so that they match and can all get appended together.

Thanks, everyone!

[June7]

I don't understand. You import one table, split into 3 tables, then recombine them into 1 table? Can you explain more about what is happening? Even provide files? Follow instructions at bottom of my post.

It is not necessary to change the table field name in order to combine with other table field. Use an alias name in the query. Is the query a UNION?

[morlasr]

Oh, I didn't know about Aliases...I got it to work. Thanks so much!