Hurrmark
06-27-2008, 01:36 PM
Hi,
I am developing a procedure that uses both Access and Excel.
In Access, I have created several tables that were extracted from a data repository meeting certain criteria. They are all the same size, and have the same field names.
In Excel, I would like to take these tables and load them into a template on a worksheet. After each time an Access table is exported into the Excel template, calculations are performed, and a new file is created that shows the results of the calculations.
Right now, I have it working so that I can load in one Access table in at a time, using the query functionalities in "External Data" and "refresh data". However, I would like to automate the process, so that each time the Access data is fed into Excel and the calculations are performed, the next Access table can be fed in right after. Essentially, the "refresh data" function is applied automatically multiple times, but instead of reading the same table, it reads a different one.
Any help would be appreciated. Thanks.
I am developing a procedure that uses both Access and Excel.
In Access, I have created several tables that were extracted from a data repository meeting certain criteria. They are all the same size, and have the same field names.
In Excel, I would like to take these tables and load them into a template on a worksheet. After each time an Access table is exported into the Excel template, calculations are performed, and a new file is created that shows the results of the calculations.
Right now, I have it working so that I can load in one Access table in at a time, using the query functionalities in "External Data" and "refresh data". However, I would like to automate the process, so that each time the Access data is fed into Excel and the calculations are performed, the next Access table can be fed in right after. Essentially, the "refresh data" function is applied automatically multiple times, but instead of reading the same table, it reads a different one.
Any help would be appreciated. Thanks.