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![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
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
![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)