How do I export Access data to a an excel Spreadsheet 1

[topgeek]

Can anyone tell me how I go about exporting data from an Access form by clicking on a button and then having Excel open automatically with that newly exported data?

Many Thanks

 

[Crowley16]

you can export with the docmd.TransferText function.

you will need to set the filename to fNme.csv for it to default to excel, (delimited text format)

if you want it to open, then you would need to use the shell commands, I can't remember off the top of my head, but F1 should be able to give you all you need...

--------------------
Procrastinate Now!