easier way to update access table from excel?
Posted on 2009-05-07
im working on a database that has a table of job tasks. my boss updates the job task on an excel spreadsheet. when he has updated a set of tasks he tells me and i get it from the network folder and start manually import to a new table. i do this by tables, new, import table,and select excel. it always has inport errors, format or something. then i go through and find/replace things to make it work. if there is a way to do an update query or something would be better. there are things on the task list that usually dont change, like task number. so i thought it would be better if i could automaticly do an update by task number. like find #1 and update the remaining fields, and on to the next.
any ideas on how to make this task easier for me?