Linked Excel Table, Update Table

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.
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Excel File won't update 1
Update Query from Access 2003 Linked Table 1
Can I edit the Path to Linked Table? 3
delet values from excel linked table 4
Append Access Data to SQL Server Table 12
Insert Into a SQL table via Access 2007 8
Linked Table Manager - Query using an Excel file 2
Linked Table Bringing in Blank rows 4

Top