Tab delimited export question

[JEB]

I have a report that I would like to e-mail in a tab delimited text file so that the recipient can import it into another data base. I do not want to have export to Excel then save and send.

Is there a way to insert the tab character in the report when I sent it as a text file?

Thanks,
Jeb

 

[johncallaghan]

You can very easily export a table using the Docmd.TransferText or Docmd.TransferSpreadsheet, see VBA help for the syntax.

If it is not a table then you will have to create the table from a query that you want to export.

cheers

john

 

[johncallaghan]

I am not thinking straight.
Probably an easier way to do this is:

DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS, "filenameIncluding Path", False (has fieldnames or not)