Home |
Search |
Today's Posts |
#1
|
|||
|
|||
external data range a two way street?
I've sucessfully set up an external data range in excel that points to an
access database query. It refreshes with no problem when making changes in Access. However I would like to be able to update cell values in excel & see the changes reflected in the Access db. I've tried playing around with the permissions but no matter what, any changes to data in excel get lost when the refresh button is hit. I'm sure I'm missing something . . . Thanks in advance. |
#2
|
|||
|
|||
Hi bicyclops --
One way street. An external data range can suck data out of Access, SQL Server, Oracle, whatever, but it can't send it back without help. I like to use a worksheet change event to trigger VBA code. That code uses DAO (or, for preference, ADO) to update the database according to the change that the user has made. Frankly, I'd rather that the user update the database directly, but these users feel lots more comfortable in Excel than in a DBMS. -- C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "bicyclops" wrote in message ... I've sucessfully set up an external data range in excel that points to an access database query. It refreshes with no problem when making changes in Access. However I would like to be able to update cell values in excel & see the changes reflected in the Access db. I've tried playing around with the permissions but no matter what, any changes to data in excel get lost when the refresh button is hit. I'm sure I'm missing something . . . Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
external data range a two way street?
"bicyclops" wrote: I've sucessfully set up an external data range in excel that points to an access database query. It refreshes with no problem when making changes in Access. However I would like to be able to update cell values in excel & see the changes reflected in the Access db. I've tried playing around with the permissions but no matter what, any changes to data in excel get lost when the refresh button is hit. I'm sure I'm missing something . . . Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
External data Macro Problem Excel 97 | Excel Discussion (Misc queries) | |||
How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) |