Linking tables in access - Please help me

[chrisgreen]

I have a table exporting data to outlook contact and I have a table importing from Navision.&nbsp;&nbsp;How can I run a query transfer certain data from the importing table to the exporting table.<br><br>Please help.

 

[kathryn]

Chris, <br><br>I am not sure if you need to do an append query or an update query.<br><br>Are you trying to add complete rows to your export table (which would be an append query) or just to update certain fields of rows which already exist (an update query)?<br><br>Kathryn

 

[chrisgreen]

The data in the export table needs to be updated with the data that has been modified or added in the imported table.<br>Can this be automated?<br><br>I hope that this has answered your question.<br><br>Thanks for your help.

 

[kathryn]

(To be safe, I would make copies of both tables and do the following on the copies)<br><br>OK.&nbsp;&nbsp;It sounds then that there is a linking field between the two tables, maybe an ID field?&nbsp;&nbsp;If so, we will use an update query.<br><br>Open a new query and add your two tables, I will call them tblImport and tblExport.<br><br>Change the query type to update.&nbsp;&nbsp;This is done on the Query menu.<br><br>In the upper pane of the query designer, click and drag from the linking field in one table to the linking field in the other.&nbsp;&nbsp;This will tell the query that you want to update the fields only for corresponding records.<br><br>We want to update tblExport, so double click on the fields in the list of tblExport that will be updated.&nbsp;&nbsp;That will move the fields down into the lower pane, called the grid.<br><br>There is a row in the grid named Update or Update To.&nbsp;&nbsp;For each field enter the name of the corresponding field name from tblImport.&nbsp;&nbsp;Use the following format:&nbsp;&nbsp;[tblImport]![FieldName]<br><br>Run the query.&nbsp;&nbsp;<br><br>Let me know how it goes.

 

[chrisgreen]

I am having trouble with my ODBC link so I haven't had time to try out your solution.