DoCmd.TransferText to SNP format 1

[startup]

Anyone know a way to export a report to the Snapshot Viewer (SNP) format with visual basic? All the transfer formats I can find in Microsoft help for the DoCmd.TransferText commands are:

acExportDelim
acExportFixed
acExportHTML
acExportMerge
acImportDelim (default)
acImportFixed
acImportHTML
acLinkDelim
acLinkFixed
acLinkHTML

 

[KellyK]

I would use
DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][, autostart][, templatefile]

and then you can use acFormatSNP as the outputformat.

example: DoCmd.OutputTo acOutputReport, "rptSales", acFormatSNP, "OutputFile"
Kelly

 

[startup]

This is perfect, just what I needed. Thanks

Rico