export button

[riffraff667]

I need to create a button when on click it exports a table to a CSV file that is comma deliminated and has double quotes for field qualifiers. The name of the file must be addmmyy.csv ie for today it would be a022306.csv.

I don't even know where to begin. Any help would be appreciated. Thanks!

 

[PHV]

Have a look at the DoCmd.TransferText method and the Date and Format functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[riffraff667]

oh and for an added demension of fun after it is done I need it to be ftp'ed to a specific ftp server.

 

[riffraff667]

DoCmd.TransferText did the trick. I didn't see anything under DoCmd.* that might allow me to ftp something though... Am I chasing my own tail on this one?