Exporting filtered set

  • Thread starter Thread starter Joseph N.
  • Start date Start date
J

Joseph N.

In Access 2003, I cannot figure out any way to export a filtered set to
a .csv (or other text) file. File/Export seems to export the entire
table, i.e., prior to running the filter. The option to export only
the selected data is only available if I click to save formatting,
which makes the resulting text file have characters that cannot be
imported well into another program, which is the whole object of the
exercise. Surely I'm missing something.... How can I export only the
results of a filtered set?
 
Creat your "filtered set" using a query rather than filtering the actual
table, this should then give you the list of only records that meet your
criteria.

Stu
 
Back
Top