Excel taking long time to import table from ODBC query.
I have ODBC query that filters .mdb file and import a table to excel. The database connection doesn't have a problem and query is also executing fine but when it comes to excel, it takes almost 30 mins to import 3000 rows. The excel connector itself doesn't respond until all import is done and freezes. We also checked if there is a resource conflict by setting it to asynch but it didn't improve the speed. Does anybody knows how we can increase the excel import speed?