Print # to text file

[rbs]

Hi Everyone,

I have a query that through a module, I wish to use the print # command. to write to a text file.

Can anyone help as to how I get the module to write all lines of the query to the text file?

Thanks in advance,


Natalie.

 

[bat17]

You will need to loop through your record set adding 1 record at a time to the text file. Write# is usually better for writing text files that you may want to use as data sources.

You could also create a query and use the TransferText method to create the text file, which could be easier/faster.

    Set qdf = MyDb.CreateQueryDef("tempTest", strSQL)
    DoCmd.TransferText acExportDelim, , "tempTest", "C:\test.txt"
    DoCmd.DeleteObject acQuery, "tempTest"

HTH

Peter

 

[rbs]

Thanks for your help.

I can't transfer the query in this way because I am saving the file as a dat file and it will not let me use this file extension.

I also don't want any delimiters in the file.

Any Advice

Thanks,

Natalie