Generic Export Format

  • Thread starter Thread starter Paul Hammond
  • Start date Start date
P

Paul Hammond

Is there a way of setting up a generic export specification that is not based
on field names? I have applications where I am exporting 3 or 4 versions
of the same query, but with slightly different field names, i.e. qry 1
requires all fields and data, qry 2 has the same structure, but some fields
use formulas or null forcing changes in the original field names. These are
being exported as delimited fields with the same number of fields. I want
to avoid having to create a new format for my VBA code to reference each time
I make a slight change in a query.

Does that make sense?
Paul
 
I assume that you're asking about exporting a query's data to a text file,
using the Export Specification option? If yes, those specifications cannot
be made generic (without specific field names being specified). An export
specification is designed to work with a specific file / query
format/structure.
 
Back
Top