_Hector
asked on
Save Access Query to multiple files
Hello,
I need some help. I have an access query that I wish to group and output by customer number as excel files.
CustomerNo
InvoiceNo
Date
The saved file names should be equal to the customerNo.
Thank in advance.
I need some help. I have an access query that I wish to group and output by customer number as excel files.
CustomerNo
InvoiceNo
Date
The saved file names should be equal to the customerNo.
Thank in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you try the
DoCmd.TransferSpreadsheet 1, 8, "Query1", "C:\" & me.Customer & ".xls", True
jaffer