split spreadsheet into multiple spreadsheets

[jammyp]

Hi,
I have a spreadsheet with location, name and odb in the rows, eg :

location name dob
1 Jo 10/02/78
1 Ste 12/03/82
2 Mik 01/11/59
3 Jop 11/11/90
3 Kat 02/05/78
3 Jo 14/04/84

How can I :

1 : Import Spreadsheet into a table
2 : Split Data into Locations and save each location to a different spreadsheet, eg. Location 1 will contain 2 records and the spreadsheet will be called 1.

If I was to save my original spreadsheet to C:\splitter\
then is this all possible from a click of a button , saving the new spreadsheets to C:\splitter\new sheets\


thank you for any help.

 

[Pat Hartman]

1. File/Get External Data/Import --- follow the wizard -- or use the TransferSpreadsheet Method to import it.
2. Create a query that selects a particular location and use the TransferSpreadsheet Method to export it. If you need to export all of the locations at once, you'll need to create another query that selects all the locations and read that recordset to control the other query and the export with the TransferSpreadSheet Method.