veryfunkymunky
New Member
- Joined
- Feb 7, 2018
- Messages
- 1
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
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
