Need help exporting partial records to external database after que

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the list of ALL registered pilots in the USA, but I want to mail to
only these with a certain type of rating. Therefore, I need to filter data
and export only those selected data to a separate and new database. So far,
I have tried to do this with MAKE-TABLE QUERY after sorting and filtering for
the data that I want. What I need to do now is to export the meaningful data
to a mailing list printer service who only uses dab-delimited text. I have
made new tables using the MAKE-TABLE QUERY and so far, it includes ALL of the
original data.
Can someone help me get this abbreviated list made for my advertiser? I
can't figure this out on my own.

I USE ACCESS 2000
 
Hi Phil,

The standard approach is to create a SELECT query that returns only the
fields you need. Use criteria in the query to select the records you
need. Then save the query and use File|Export to export it. Options in
the export wizard let you select tab-delimited.

On Sat, 10 Feb 2007 13:49:00 -0800, Phil Mc <Phil
 
Back
Top