Excel/Access Traversing

[veryfunkymunky]

Afternoon All

Does anyone know if.... an excel formula can traverse a data connection into an access database?

The scenario is we want to implement a dashboard, but the only way to implement appears to be by pulling the data records into excel. Was trying to see if there is a way to have the formula just link to the database, a bit like how we use a pivot over connection.

any help is much appreciated.

Rob

 

[ranman256]

access doesnt read the formula , it just gets the value.