Update and append new data (1 Viewer)

[jamphan]

I have a table that I need to update existing data and append new data. All of the new data is in the same file. Is there a way I can update and append at the same time?

 

[pbaldy]

This might work:

http://support.microsoft.com/kb/208870/en-us