Copy and Paste a column from another table

[julioczg]

Hi guys,


I have two tables (table A and table B) and into each table have 100 rows. So I need to copy one column from table A (with the same rows) to another table B.

Someone could help me?

thank you

 

[Rx_]

More details would be helpful. Here is a couple of suggestions.
1. Do the two tables have anything in common so they can be joined in a Query?
if yes - Create the new column in table B - Join the two tables in a query - create an Update Query.

2. Lets assume that you have two tables and the data in each column just magically matches. So all you really want to do is basically copy a column from one table to another.
If both tables have an Autocounter field - go back to the instructions above - joint the autocounter in a query and perform an update query.
If neither table has an autocounter field -
well - my train gets here in 5 minutes and I don't have the time to describe all the steps... so
Copy all from table 1 and paste it into an Excel Worksheet
Copy all from Table 2 and past it into an Excell Worksheet
Get rid of the columns you don't want - tidy up the data.
Now, use Access Import External Data - and create a new table based on importing the new Excel worksheet.
Rename your old table - name this new import to the old table's name.

 

[boblarson]

The question suggests a possible problem with the database structure. More information, as requested by RX would be good but also more about why you have two tables like this, what is the purpose, how does the data get there?

 

[julioczg]

I have two tables because table A is a value from accounting and table B is a description from table A. The same number of entries, but there isn`t autocounter.

So, I`m studying any possibilities.

Is there a possibility I create a new table C and put the values from Table A and Table B with many lines, with 2 columns?

I dont know to do this with SQL Command.

Thank you

 

[julioczg]

Basically, i have tabela 1 and tabela 2.. And I Created the tabela 3 to consolidate.

Anybody knows?

Thank you

 

[pr2-eugin]

Why do you need to Create a New table? You have the right structure.. Two tables they are related to each other by a common 'CONTADOR'.. So why another table?

 

[julioczg]

Yes, I dont need just create another table.

I can put Campo4 into tabela 2 using SQL, because its a sequency of tables to do this.


Do you know?

 

[Rx_]

Many possibilities depending on what the end result should be.

One way is to take the 2nd table - add the field.
Then perform an update query.
The number field can be joined.
The update query can move the data over from 1st table to 2nd table.

Attached: general diagram.