• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula in Excel If database is in access

M

MohitMathur1234

Member
Hi All,

Quick Question,

I have huge data in excel which is getting slow to my excel workbook,
Can I use access as database and use formula in excel using database as access.

Please suggest,
 
Not via formula directly. But you can do something like following.

1. Build View in Access. Limiting data to segment that's of interest
2. In the same View add transformation steps as needed.
3. Connect to View in Access via MS Query or PowerQuery (Get & Transform) and load data as connection only and add to Data Model.
4. If necessary, do additional transformations (Join with table in Excel etc) in the respective query editor.
5. Load result to sheet or summarize using PivotTable
 
You must log in or register to reply here.
Back
Top