Split master table into smaller tables

[atahim]

I have a master table with over 300,000 records that i need to split
into 500+ smaller tables. I have a branch field in the master that i
can use as an identifier. I even created a branch table that lists all
the 500+ branches that i have. Basically i want to create these new
tables and then export them into 500+ xls. files. Is there a VB routine

that someone might have to facilitate this. Thanks!

[pietlinden]

Not really. Maybe the easiest way is to create a unique values query
on the BranchID and write that to a new table. Then you can loop
through thatt table, passing the BranchID to a SELECT query and output
the whole mess to an Excel file. That's infinitely easier than doing
something 500 times... A few things to look at...

Querydefs,
TransferSpreadSheet

Umm...Dev's code for dumping a recordset to Excel using automation...
(I'd start there!)
www.mvps.org/access
Just look up Excel.