Generic Export Format

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
 
K

Ken Snell \(MVP\)

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top