Linked Excel Table, Update Table

  • Thread starter Thread starter dmasch
  • Start date Start date
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.
 
Microsoft lost a lawsuit a year or two ago and were forced to remove the
ability to update a linked spreadsheet from Access.

Sorry, but you'll need to come up with an alternate approach.
 
Back
Top