There is a table tbl1,with several fields, one of them is City, with the
value varies from city1 to city30.
I want to use Access Marco to automatically using function
transferspreadsheet to copy this tbl1 into 30 excel sheets, by the value
of
city. For eg, select * from tbl1 where city value=city1 , then put the
selected records into excel file “\…\…\city1.xls”,
Thus generates 30 excel files.
Is there a simple way to achieve this, avoid writing 30
transferspreadsheets in a macro?
Thanks.
Dawn
|
