We am importing/fetching data from a Server into Microsoft Excel via ODBC connection. For a data set with 5 columns and 10000 rows it is roughly taking 10mins to pull data. The time to import/fetch data to excel increases when the columns increase.We can confirm that the Network connection is fast and is not the cause for slowness.
Is there any way we can decrease the time taken to fetch ? Increase performance of import/fetch ? Any best-practices or tuning which needs to be done. ? We are using excel 32 bit v16 and windows 10.