access--excel--access
 

I have a table in acess linked to excel by a query in excel so that when i update the access table the excel table updates when i refresh it but i would like the access table to update when the excel table is updated. Same process only reversed somehow.

access--excel--access
 

In Access, you can link to the Excel table (FileGet External DataLink
Tables)
Then, you can make changes in either Access or Excel.

Tim wrote:
I have a table in acess linked to excel by a query in excel so that when i update the access table the excel table updates when i refresh it but i would like the access table to update when the excel table is updated. Same process only reversed somehow.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

access--excel--access
 

'A query in excel' - MS Query? Such a query read only, there is no
functionality provided to update the source. So you'll have to write
your own. Take a look at ADO.

--

Tim wrote in message ...
I have a table in acess linked to excel by a query in excel so that when i update the access table the excel table updates when i refresh it but i would like the access table to update when the excel table is updated. Same process only reversed somehow.