Forum Discussion

Will Golay's avatar
Will Golay
Copper Contributor
Jun 19, 2017

Create Microsoft Access Query or Speed Up Refresh Time for OLE DB Type Queries

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/19658485-create-microsoft-access-query-or-speed-up-refresh   Suggestion: Using the legacy wizards, it is...
BI & Data Analytics
Requests
Guy Hunkin's avatar
Guy Hunkin
Icon for Microsoft rankMicrosoft
Jun 26, 2017

Hi Will,

 

Can you please elaborate on your tests? How large is the dataset? Did you choose to create relationships? Are you importing into the data model or grid?

 

Guy

- Excel Team

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 26, 2017

Hi Guy,

 

Will gives much more details. I'm not working with Access, but for my interest tested the connection on some tiny demo database i found in Internet (file size ~800KB and 10 small tables insides).

 

If load into the data model there we have lot of relationships (built automatically or imported from database, i don't know) Refresh takes more than a minute.

 

Legacy connector also adds everything into the data model, but refresh takes just few seconds.

Resources