Access 2003 General QuestionLocked
I have 2 DB’s, db1 and db2. I need 3 columns (i.e. first name, last name, email)from table A on db1 to update 3 columns on table B on db2 automatically. The columns are not named the same way (i.e First_Name on db2, Firstname on db1). Is this possible or am I dreaming? Please be as detailed as possible. Access is my Achilles heel. Thank you.