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.

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.

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.