Saving results of filter to new table or database

[opainc]

I am trying to subdivide a large (160,000 records) table into smaller databases.

How do you save the results of a filter as a new table/mdb?

 

[PHV]

Have a look at MakeTable (SELECT ... INTO) and/or Append (INSERT INTO ...) queries.

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

 

[SkipVought]

Hi,

May I ask WHY you need to segment data into separate databases?

Skip,

_[red][/red]

 

[opainc]

My mistake in typing. The mdb has 1,600,000 records.

All data is in caps. I want a subset of 5000 that I can change into First letter cap rest lowercase and then develop a mailing list. In the past I have exported into word for the case transition and then into excel for the mailing.

I sure this could be done directly in Access by a capable programmer. I am not.

 

[PHV]

I sure this could be done directly in Access by a capable programmer. I am not.
So why not hire somebody ?

 

[opainc]

PHV- Whys.

Retired, not for profit, too cheap. Besides it's a challenge to learn new things, or even remember old things after 75.

 

[willybgw]

Use StrConv([field name],3). This will make first character of every word upper case, all other letters lower case.

willybgw