Hi All,
We have few MS Access files (Around 600 MB each, with 7,00,000 lakh rows of data) saved in a stand alone system acting as Server.
I have created an ODBC connection from users system to the server,& connected through Microsoft Query. However when I try to extract data the excel file goes to not responding mode or causes lot of delay in data extraction.
Is there any way that I can optimize this, please.
Thanks & Regards
Raj