Speeding up msaccess

[mac1980]

oki i have an exel program that works with access, i store data around (1400 cells from various sheets) per one scenerio ... db is 5 tables with only one huge (1400*scenerios) ... it takes around 30 second to read and write from it ... is there a way to make it quicker or it's the way access works ... i'm using ADO to manage Access

recordset.addnew and .update .. maybe theres oder abit quicker way ?

 

[SydneyGeek]

Access works MUCH faster with internal tables than linked Excel tables. How often does the Excel data change? If the main data doesn't change constantly, or you only want to report once a week, consider importing the Excel data to an Access table. It'll be a whole lot quicker to run the reports.

Denis