TransferText specification name?

[shacket]

I want to export a query to an HTML format. To use DoCmd.TransferText, it asks for a specification name. The help file says: "A string expression that's the name of an import or export specification you've created and saved in the current database." How do you create that?

 

[Pat Hartman]

Go through the process of manually exporting/importing the file ONCE. At the last screen of the wizard, press the Advanced button and give the spec a name so you can save it. Once it has been saved, you can refer to it by name in the TransferText Method/Action.

 

[shacket]

I tried to do that and can't seem to get a wizard going. I am trying to export a query to an HTML format.

Thanks for any other help you can give me.

 

[pcs]

shacket,

From Access Help:
You can use import/export specifications with HTML files, but the only part of the specification that applies is the specification for data type formatting.

if you don't need to change the formatting you might try using OutputTo method instead.

like:
DoCmd.OutputTo acOutputQuery, "YourQuery", acFormatHTML, "c:/YourPath/YourFile.htm", False

hth,
al


[This message has been edited by pcs (edited 10-14-2001).]

 

[shacket]

PERFECT! Thank you very much!