How do you move data from one table to another table on a sql data

[Guest]

I have a sql database that has 2 tables that have the same columns that I
would like to combine and remove one of the tables...how do I do that?

 

[Jeff Boyce]

Why? As in "why have you decided that you have to move a copy of data from
one table to another?"

I ask because there are many instances in Access in which folks think they
have to move data or make copies of data, when in fact, they don't. There
are usually other ways to accomplish the underlying need.

Can you describe the need?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rick B]

Do you need to know which table they came from? If so, add a "type" field
to establish it and update it for all the records first. For example, if
one table contains records from "North office" and the other contains
records from the "South office", then you might want to add an "Office"
field to your tables and update it before you go any further.

Once you are ready to merge the data, build an APPEND query to copy the
records from one table to the other. Or, just highlight all the records and
copy them, then paste them to the other table. Then delete the unneeded
table.

 

[Jeff Boyce]

My bad! I misread your post.

If you are removing a table and consolidating its data into another, you
could use an Append query from within Access...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I started a database website for a business using a database at the
website...now I can use a sql server and would like to use it...but I need to
transfer the data from the access file into the table on the sql server...I
have figured out how to import the table into the sql server but I need to
move the old data into the new table...I tried copying and pasting but that
didn't work....