Is it possible to Sort, filter, save as .csv

  • Thread starter Thread starter JohnW
  • Start date Start date
J

JohnW

I hope I've got the right group.
Is it possible to macro the following:
1. Sort a table by field - e.g. "Pets_Owned"
2. Filter all occurences to a seperate file - e.g. "Dogs" or "Cats"
3. Save this file as a .csv - e.g. dogs.csv or cats.csv
4. Without having to enter the search and save as criteria.

Any suggestions would be helpful.

I have a table with about 5000 records that will be broken into 145 files
for distribution and I really dont want to wear out my keyboard.

Thankyou in advance.
 
Hi JOhn
1. Sort a table by field - e.g. "Pets_Owned"
Click to expand...
Create a query based on the table and sort that.
2. Filter all occurences to a seperate file - e.g. "Dogs" or "Cats"
Click to expand...
Create another query and Like "Dogs" or Like "Cats" in the criteria row
3. Save this file as a .csv - e.g. dogs.csv or cats.csv
Click to expand...
Use output object - select the format from the dropdown
4. Without having to enter the search and save as criteria.
Click to expand...
Run the export from the filter query (Like "Dogs" etc etc)
 
Thanks for your help Wayne,
There's still some operator input in your suggestion, I was hoping there'd
be a simpler method.
I think I may have over simplified my original explanation, the sort
criteria is actually store codes (145 different that follow no patern).

I might have to export the sorted table to a file and split it with notepad
- yuk
Thanks anyway
Regards,
JohnW
 
Back
Top