View Full Version : How to create an update query?


fmcampos
02-03-2002, 01:24 PM
What I need to know is how to create an update query that gets data from a linked table (excel sheet) and constantly updates it on a new table... Hope anybody can help..

Pat Hartman
02-04-2002, 04:16 AM
Try this article:

ACC: Updating and Appending Records in One Update Query (Q127977)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q127977

fmcampos
02-04-2002, 04:59 AM
Thanks, got it already.. http://www.access-programmers.co.uk/ubb/smile.gif