|
| |
|
|
lu lu
Posts: 418
From: wpg, mb
Status: offline
 |
access database copying - 8/3/2006 13:57:17
Hi, i'm trying to copy 57000 records from one column in a table and add it to another column in a different table. I'm trying this off-line, with just the cut n paste / clipboard
but i'm running out of memmory, Does anyone know of how to increase clipboard memory on a windows machine or how to run a query in access to add records to a specific column from a specific column amoung two tables in teh same databse both of wich have no primary key or auto incrementing field?
thanks
|
|
|
|
swoosh
Posts: 1438
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: access database copying - 8/3/2006 14:03:24
Have you tried the Append Query?
It will add the new column but as new records. I'm not sure that's what you want or are you looking to add the data to already existing records?
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
yb2
Posts: 653
Joined: 1/30/2006
Status: offline
|
RE: access database copying - 8/3/2006 19:39:53
For new records
INSERT INTO NewTable
( NewColumnName )
SELECT OldColumnName FROM OldTable
For existing, if you want them to be in a certain order then you need to supply a relationship in the JOIN or WHERE clause - join is best.
UPDATE NewTable
SET NewColumnName = o.OldColumnName
FROM OldTable o
INNER JOIN NewTable n
ON o.id = n.OldTableId
_____________________________
it is natural for people not to see one's own faults, and to exaggerate other people's faults and failings.
Currently listening to: L'Enfer Des Formes by Stereolab
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
