Results 1 to 2 of 2
  1. #1
    antoniorossano is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2009
    Posts
    2

    Access append query

    Hy I'm Antonio from Italy. I need help to create a query (SQL) in MS Access
    2003 that appends data in two identical tables named "tblUsers" stored, the
    first (A) on local database logon.mdb and the second in another local
    database (B) stored in "E:\utenti\logon.mdb", but i need to append only the
    new records of database A that doesn't exist in database B. Someone cab help
    me with the exact expression and grammar to do this?


    many thanks everybody !! ;-)

  2. #2
    antoniorossano is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2009
    Posts
    2

    extend

    the two databases names is the same: logon.mdb
    the two tables names are the same: tblUsers.
    this is the query i wrote, but it doesn0t work: what is bad?
    The query, without the clause WHERE, works fine. but with that clause makes
    an error "incorrect database name" (strange). But without that clause it
    still append all records and not only tha are new in he master.
    INSERT INTO tblUsers ( UID, PWD, COMPARTIMENTO, UFFDOGANE, COGNOME, NOME,
    INDIRIZZO, CAP, COMUNE, PROVINCIA, TELEFONO, CELLULARE, TELEFAX, EMAIL, WWW,
    ID, ADMIN, ENABLED, YEARENABLEDDATE, MONTHENABLEDDATE, DAYENABLEDDATE,
    COD_Questionario ) IN 'E:\Documenti Antonio\Siti Web\CoNaSpDo\FAD\FAD\
    riservato001\_private\logon.mdb'
    SELECT tblUsers.UID, tblUsers.PWD, tblUsers.COMPARTIMENTO, tblUsers.UFFDOGANE,
    tblUsers.COGNOME, tblUsers.NOME, tblUsers.INDIRIZZO, tblUsers.CAP, tblUsers.
    COMUNE, tblUsers.PROVINCIA, tblUsers.TELEFONO, tblUsers.CELLULARE, tblUsers.
    TELEFAX, tblUsers.EMAIL, tblUsers.WWW, tblUsers.ID, tblUsers.ADMIN, tblUsers.
    ENABLED, tblUsers.YEARENABLEDDATE, tblUsers.MONTHENABLEDDATE, tblUsers.
    DAYENABLEDDATE, tblUsers.COD_Questionario
    FROM tblUsers
    WHERE tblUsers.UID<>[E:\Documenti Antonio\Siti Web\CoNaSpDo\FAD\FAD\
    riservato001\_private\logon.mdb].[tblUsers.UID];

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  2. Control Value Select Append
    By NinjasVsPirates in forum Programming
    Replies: 0
    Last Post: 08-18-2009, 10:42 AM
  3. append to memo field
    By stuart rose in forum Programming
    Replies: 1
    Last Post: 08-12-2009, 10:02 AM
  4. Microsoft can'd append all the records
    By noidea in forum Access
    Replies: 1
    Last Post: 08-01-2009, 09:28 AM
  5. Replies: 2
    Last Post: 05-27-2009, 08:47 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums