By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

updating all data form one table to another

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.