By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Customizing data export without using Export specification

P: 10
I have a table, from which I created a cross tab query. I need to export the crosstab query so I created a export specification selecting the following options, Tab Delimited, Include filed names on first row and no text qualifier, however because the query layout is dynamic sometimes I get an error that the number if columns in the specification and in the query don’t match as I am using a “TransferText” macro. If I do the export and don’t select any specification it uses comma Delimited, text Qualifier as (“) and does not include field names in first row. Is there anyway do change this default wizard settings or some other code so that the three options will match what I want.
Jan 29 '09 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
I'm fairly confident the answer is "No" I'm afraid.

I've played quite a bit in that area and I can think of no way, other than manipulating the tables which store the spec details, of varying the settings you need.

The procedure call certainly doesn't allow you much scope. You can write the data out manually, of course, but as for using a standard part of Access to help with it, I think there's nothing for you.
Jan 29 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.