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.

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

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