Export to Excel

[52]

I'm trying to save Access data to Excel. I will need to have spreadsheets with each name: (there is a field in the table with each name in it)

Bob
Joe
John

Each spreadsheet needs to be named their own name. In this example, I'd have Bob.xls, Joe.xls and John.xls -- each with their own data (Bob can't see Joe's data)

Is there a way to do this automatically?

Thanks!!

 

[PHV]

Take a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886