Export to Excel

[tps131]

I have a form with infomation that users are going to be inputting into a combo box and two or three text boxes..I want to be able to have the user after filling out the form to click on a command button and export those fields to an excel spreadsheet from there an admin can review responses before importing back into the accesss application..Any helpful guidelines or procedures??

 

[PHV]

Take a look at the DoCmd.TransferSpreadsheet method.

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