Filter, Export and Format

[opainc]

I have a very large table 1,500,000 records.

It is all in caps and the last name,first name are in one field seperated by a comma.

I am trying to filter down to a specific 47000 records, export to .txt, and use "!" as the delimiter. That way Word can change , to "!". Word can also alter the caps to leading caps. Then I can export to Excel for my mailing list.

Every time I export my 47000 records all 1500000 get ported over. Can I make a new table out of the filtered 47000? Else what is a workaround?

 

[PHV]

Have you tried to retrieve your 47000 records with a query ?
You can then export the query as it were a table.

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

 

[MrSmurf]

Hi opainc

I think you should be able to do the things you want to do within access.

If you setup a routine, you could run a query which outputted your records into a temp table in Title Case, or straight into excel.

This link

http://support.microsoft.com/default.aspx?scid=kb;EN-US;291323

shows how to change the case within excel. Hope this helps

MrSmurf

 

[opainc]

Thank you PHV and MrSmurf.

At the age of 73 I have trouble learning new languages. I guess a macro isn't much different from Quickbasic with which I have some experience. I'll give both of yur methods a try.