updating all data form one table to another

[steve]

Hello, I am trying to take all the data from one table and transfer it
to another table with exactly the same column names in the same
database. I have done this with a small sql script in an update query
but now can't seem to figure out how. =(
I am doing this because one of the tables is a linked table to a mysql
table and I am copying the data then deleting the original table which
is in access 2000.
Thanks for any help
steve

[Tom van Stiphout]

On 21 Apr 2004 19:52:12 -0700, st*************@yahoo.com (steve)
wrote:

Try this:
insert into NewTable
select * from OldTable

-Tom.

Hello, I am trying to take all the data from one table and transfer it
to another table with exactly the same column names in the same
database. I have done this with a small sql script in an update query
but now can't seem to figure out how. =(
I am doing this because one of the tables is a linked table to a mysql
table and I am copying the data then deleting the original table which
is in access 2000.
Thanks for any help
steve

[Ray]

st*************@yahoo.com (steve) wrote in message news:<49*************************@posting.google.c om>...

Hello, I am trying to take all the data from one table and transfer it
to another table with exactly the same column names in the same
database. I have done this with a small sql script in an update query
but now can't seem to figure out how. =(
I am doing this because one of the tables is a linked table to a mysql
table and I am copying the data then deleting the original table which
is in access 2000.
Thanks for any help
steve

Hello Steve,

Perhaps you could use a "Make Table" query.

Ray

[Eric Ellsworth]

Hi Steve,
Note that if the MySQL table does not already exist, you will need to
create it, either using a pass-thru query, or some other tool to work in
MySQL. Once that's done you can use the INSERT statement posted above.

Cheers,

Eric

steve wrote:

Hello, I am trying to take all the data from one table and transfer it
to another table with exactly the same column names in the same
database. I have done this with a small sql script in an update query
but now can't seem to figure out how. =(
I am doing this because one of the tables is a linked table to a mysql
table and I am copying the data then deleting the original table which
is in access 2000.
Thanks for any help
steve