Saving one table in different xls files

[Catoal]

Hi,

I've got a db with more than 500000 records. Each record is associated with a group number. I've got 200 different groups. I would like to export each group separately in different files(1 by group) xls or other format.

Is it possible to do that with a macro or a module?
Could yo uhelp me?

 

[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 FAQ222-2244

 

[Catoal]

I've tried this method but it doesn't split my data!
I can create a query that select only one group but as I run my macro it only overwrite my previous file instead of creating a new!

Something else?

 

[PHV]

Get rid with macro and play with VBA.

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

 

[Catoal]

Arguments are the same in vba for this command!!!

 

[PHV]

In VBA you can looping the group number and dynamically assign the spreadsheet name.

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

 

[Catoal]

Great that's what I want!
How to do that?