mpuska

I am mpuska, from Zagreb, Croatia, Europe.Database, documentation etc. is my occupation for the moment.Hi to everybody :-)

Problem solved!Solution for my problem was here:http://www.techonthenet.com/access/queries/update2_2007.phpThe SQL will update the MFG field in the Bot table with the value in the MFG field in the Big table when the PART values match:UPDATE Big INNER JOIN Bot ON Big.PART = Bot.PART SET Bot.MFG = [big].[MFG];Thanks for your help!

Incorrect, table 1 (source of new data) has 4000 rows (has 2 columns - 1st column has 4000 data, same data as 1st column of table 2) and table 2 has 6000 rows (has more data and many rows are inserted by users, is more accurate of table 1, but with empty cells in column 2, cells to be updated with the content from source table, from column 2).I have to insert new data into table 2 (table with 6000 rows) into 2nd column, but only where data in 1st column of table 1 and table 2 are the same. Order of data in two tables (1st column) is not the same. Many data in table 2 are in last months deleted

I am trying to insert new records into second table. New records in database (from 4000 up) are allredy added by users and I must insert records (new content into existing cels) into old part of datebase (from 1 to 4000 records).

Thank you very much for your help with http://office.microsoft.com/en-us/access/HP010322451033.aspxThe problem for me is how to write a statement with CONDITION to copy new data from TableA (Column2) into TableB (ColumnY), ONLY WHERE the content in Column1 from TableA is equal to content of the ColumnX from TableB. How to write CONDITION where to execute INSERT INTO and where not. 2 tables are in the same database. Can you write for me a statement using names of tables and columns from my example? Thanks!

Can you write for me SQL statement SELECT INTO and I will try in Access to do that. Or I have to update more then 4000 records one by one. Thanks!

Hi! How to insert different text into MS Access database (base.mdb) from TableA (Column2) into TableB (ColumnY), but only where the content in Column1 from TableA is equal to content of the ColumnX from TableB. Column1 in TableA and ColumnX in TableB are almost the same, but not equal, and I need to add data into TableB (ColumnY) from TableA (Column2) only for equal data in Table A and B. See examples for results I need (in red): TableA Column1 | Column2 ----------------- text1a | text2a text1b | text2b text1c | text2c text1d | text2d text1e | text2e TableB ColumnX | ColumnY -------------