INSERT SELECTED DATA INTO NEW TABLE 2

[JONBOY74]

HI ALL

I'M A BIT NEW TO ACCESS SO SORRY ABOUT THIS REQUEST

I HAVE 2 TABLES AND THROUGH OUT THE DAY I WISH TO UPDATE THE SECOND TABLE WITH NEW DATA IN THE FIRST TABLE.

THE DATA HAS GOT A ID NUMBER, SO I WOULD LIKE TO DO SOMETHING LIKE THIS

INSERT INTO TABLEA
SELECT * FROM TABLE
WHERE TABLEA.IDNUMBER <> TABLEB.IDNUMBER

PLEASE HELP

JON

 

[THoey]

Try:

INSERT INTO TABLEA
SELECT * FROM TABLEB
WHERE TABLEB.IDNUMBER NOT IN
(
SELECT TABLEA.IDNUMBER
FROM TABLEA
) Terry M. Hoey

 

[JoanieB]

You can also run an update query: Select all fields to be updated and specify the &quot;Where&quot; criteria under the ID field
(where UpdatedTable.ID <> NewTable.ID)