473,320 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

updating all data form one table to another

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
3 2474
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Jason | last post by:
Let's say I have an html form with 20 or 30 fields in it. The form submits the fields via POST to a php page which updates a table in a database with the $_POST vars. Which makes more sense? ...
3
by: Ryan.Chowdhury | last post by:
This is a general question regarding the use of view and stored procedures. I'm fairly new to databases and SQL. I've created a SQL database using an Access Data Project ("ADP") and I'm...
4
by: Laura | last post by:
Here's the situation: I'm trying to use an update query to copy data from one row to another. Here is the situation: I have 5 companies that are linked to each other. I need to show all 5...
3
by: Tc | last post by:
Hi, I was curious, I am thinking of writing an application that loads a dataset from a database that resides on a server. The question I have is this, if multiple copies of the app will be...
4
by: Darrel | last post by:
I'm creating a table that contains multiple records pulled out of the database. I'm building the table myself and passing it to the page since the table needs to be fairly customized (ie, a...
10
by: jaYPee | last post by:
does anyone experienced slowness when updating a dataset using AcceptChanges? when calling this code it takes many seconds to update the database SqlDataAdapter1.Update(DsStudentCourse1)...
4
by: Geoff | last post by:
Hi I'm hoping somebody can help me with the following problem that has occurred to me. Suppose I have two tables in an SQL Server database. Let's call these tables A and B. Assume that A has...
33
by: bill | last post by:
In an application I am writing the user can define a series of steps to be followed. I save them in a sql database using the field "order" (a smallint) as the primary key. (there are in the range...
0
by: C-Note | last post by:
This is a simple MS Access 2003 Project file (*.adp). It accesses a SQL Server 2005 database on the network. It has 10 tables. Everything updates, deletes, inserts, adds without a hitch, except...
2
by: =?Utf-8?B?VmFuZXNzYQ==?= | last post by:
Hi All! I am with a situation where I am not getting the right updating to the form's fields. The situation is the following one: I have one combobox and one textbox. I am using the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.