Hello,
I have a big table of cost centre spend in access (About 1 million records) and need to run queries to create smaller tables that I can put into Excel 2003 (so 65000 rows limit).
I need to create a table for each combination of "country" and "department" (there are a different number of departments in each country so I can't hard code), put each table into a new excel document (none of the tables will have more than 65000 lines), and then close and save each new document.
Please can you tell if/how I can do this with Access VBA?
Thanks,
Poiu
I have a big table of cost centre spend in access (About 1 million records) and need to run queries to create smaller tables that I can put into Excel 2003 (so 65000 rows limit).
I need to create a table for each combination of "country" and "department" (there are a different number of departments in each country so I can't hard code), put each table into a new excel document (none of the tables will have more than 65000 lines), and then close and save each new document.
Please can you tell if/how I can do this with Access VBA?
Thanks,
Poiu