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?
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?