Hi Debbie - thanks for the reply.
Our workflow is as follows:
Automation runs SQL against several external databases (Oracle, SQL Server, MySQL) collecting monthly data and appending the data to Local Storage tables (about 100 million rows of data so far!)
Further automation then extracts the last 12 months of data from the Local Storage tables and exports this data to MS Access databases - from which we link multiple spreadsheets which contain many graphs.
I’m sure you can see that this is quite a garganuan task and TDP makes life a whole lot easier with it’s automation features.
But . . . .
We are running into the limitations of MS Access database sizes (and the amount of time TDP takes to export the data each month).
If we could simply plug our speadsheets via ODBC into our Local Storage tables then it would bypass about a days worth of exporting and circumvent the need for all the problematic Access databases.
It may be that there is a better way to produce our thousands of graphs each month - I’m open to suggestions (but they would need to be quicker and less effort to make changing our process worthwhile).
I’m interested in your opinion?