Export from Crosstab query

[MatMac]

I wish to export data based on a crosstab query. As such, for any given export dataset it is not possible to know in advance the exact list of fields which will be re constructed by the crosstab query.

However, I need to set up an export spec to run the export process from a macro using TransferText, but an export spec requires fields to be listed. All I need to do is tell the process to export as delimitted text.

Any idea? Thanks.

 

[yellow]

If you want to do this using a macro. Create a new macro. Select TransferText. Change the type to Export Delimited and leave the Specification Name blank. Fill in the remaining details as required and it will export the query...

 

[MatMac]

Thanks v much for that.

 

[maxmangion]

you can also do it in VBA by using Domcd.TransferText

It is more recommended than using Macros.

 

[entnervt]

Don't !

I highly recommend if you want to export to a comma seperated textfile: prefer the MACRO method and do not use VB. Instead call the macro in VB then with docmd. The VB method CAN bring up a LOT of problems and bugs in Access which the macro version doesn't. In this case the macro can save you hours. (I normally don't use ever macros, I am a 100% coder.)

Who cares if someone says VB has to be preferred? For me simply counts that it works!