Guest_imported
New member
- Jan 1, 1970
- 0
How do I copy a column of data from one Paradox table to another Paradox table.
Wilbert
Wilbert
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I copy a column of data from
- Thread starter Guest_imported
- Start date
- Status
If the second table doen't already exist just query the column and change the name of the answer table.
If the second table already exists then do an insert query
table1 | column |
| _join1 |
table2 | column |
insert | _join1 |
if the second table has values and you want to change already existing records use a changeto query.
table1 | linkfield1 | linkfield2| column |
| _join1 | _join2 | _Join3 |
table2 |linkfiled1 | linkfield2 | column |
| _join1 | _join2 | changeto _join3 |
HTH,
Richie
If the second table already exists then do an insert query
table1 | column |
| _join1 |
table2 | column |
insert | _join1 |
if the second table has values and you want to change already existing records use a changeto query.
table1 | linkfield1 | linkfield2| column |
| _join1 | _join2 | _Join3 |
table2 |linkfiled1 | linkfield2 | column |
| _join1 | _join2 | changeto _join3 |
HTH,
Richie
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question