Exporting table using code?

[Barry Phillips]

Is it possible to have a button click automatically export a file by code?
Please provide code if known. I know I can use Sendobject to export and emial
but how do Ijust export?

What I am trying to do is set a button to export a table to be used to print
mailing labels. I need to export the table in either excel format or .CSV
format. I do not need to email it but just want it exported to a file folder
for later use with Avery label maker software.

any help is greatly appreciated.

 

[Ken Snell [MVP]]

Check out TransferText (for text files, including .csv) or
TransferSpreadsheet (.xls) in Help.

 

[Barry Phillips]

Thanks Ken,

That did the trick

Check out TransferText (for text files, including .csv) or
TransferSpreadsheet (.xls) in Help.

 

[SSgt Jim]

I need to make a button that when clicked will export tables into another
database.