D
dmasch
Using Access 2002. I import an Excel table into my database that is
regularly updated from my company's main database via a BusinessObjects
query. I need to create a table that constantly updates to mirror the linked
Excel table because of record locking issues (can't have multiple people in
the database if queries are based on the Excel table). I use a make-table
query as a starting point... My question is how do I keep the table updated?
Thinking I need to do an update query, a delete query and/or an append query
but not sure how or in what order. Any help would be appreciated. Thanks.
regularly updated from my company's main database via a BusinessObjects
query. I need to create a table that constantly updates to mirror the linked
Excel table because of record locking issues (can't have multiple people in
the database if queries are based on the Excel table). I use a make-table
query as a starting point... My question is how do I keep the table updated?
Thinking I need to do an update query, a delete query and/or an append query
but not sure how or in what order. Any help would be appreciated. Thanks.