Add/Update Data Field

[dhen21dx]

Hi,

Can anyone help me, i have an existing database and i need to upload file with an updated data in some fields and other are new records. how can i do that. Let say i have Primary Key.

Thanks.
Dennis

 

[GinaWhipp]

In order to change fields in an existing table you must use an UPDATE query. And you will need a PK in both tables that match or your UPDATE query won't execute correctly. To add new is an APPEND query. You cannot do both of these in the same query.