*preface, I am a newbie (this should be easy)
I want to migrate my customer information from one table to another table.
The table in called Customers, the other is called CustomersOLD.
They have different column names, like lname and LastName.
I want to get all the data from CustomersOLD into the Customers table.

How do move the data from one table to the other. I plan on deleting the CustomersOLD table. (or not use it).

Thank you kindly.

*preface, we've all been newbies, your in good company.

It may be easy....

is Customers empty?

Are there other tables in the database related to CustomersOLD? If so is this important to maintain?

Are all columns in CustomersOLD you want saved existing in some way in Customers?

Are there any required fields in Customers that do not exists in CustomersOld and do not have default Values?

Are there any Columns that you feel match but have different dataTypes or constraints?

If customers is empty ( and possibly regardless) then you may be able to use a standard append query depending on answers to the above.

You could just backup your db and give the append query a try and see if you need further help.

Good Luck!

is Customers empty? No (but I could easily make it)

Are there other tables in the database related to CustomersOLD? If so is this important to maintain? (NO)

Are all columns in CustomersOLD you want saved existing in some way in Customers? (Yes)

Are there any required fields in Customers that do not exists in CustomersOld and do not have default Values? (Yes, I'll just leave them blank ?)

Are there any Columns that you feel match but have different dataTypes or constraints? NO (maybe the Date of Birth)

If customers is empty ( and possibly regardless) then you may be able to use a standard append query depending on answers to the above.

=================
HOw does an append query work ?

It's a pretty handy thing really.

Select create query in design view

ADD the table CustomersOLD

From the menu select Query/Append Query

You are prompted for a table name to append to
Select Customers
And click OK

In the row labeled Field: , select the columns from CustomersOLD
in the row labeled Append To: , select the column you want to map to in Customers.
Once you've mapped all your columns in this way, Run the query.


PS if the fields are actually set to required and they have no match in the other table then you may have a litle more work to get this to run.