Search results

but... yes.. i am using query to extract specific data from Access and then put into excel spreadsheet. 1 day 1 query

VBA code, yes. loop days and stocks

my access database contains over 3million rows and the size will be increasing. it's used to store the history price of stocks. The problem,as I mentioned, is the speed for exporting. it takes 1: 30secs for 2300 dates * 1 stock 2: 1 min for 250 dates * 25 stocks 3: 5.5 mins for 7200 dates * 5...