Programming a command button to export data

Connor

Registered User.
Local time
Today, 03:47
Joined
Oct 21, 2005
Messages
18
I know this topic has been discussed, but i could not find one thread on the general purpose of exporting an excel table/form to excel.

I would like to place a command button on my FORM, and let the user click this button and export the data into excel.

I tried using the transferspreadsheet method, but could not corrrectly, if at all get it working, and the help section within access2003 onlu covered importing into access from excel.

Please, if anyone has any links to sites/tutorials/ threads i misssed actually covering this topic/or thier own help, it would be greatly appreciated.

Thanks

Connor
 
Hello Connor!

Look at "DemoQryToExcelA2000.mdb", I think it's what
you need.
 

Attachments

Thanks

Thank you So much, works wonderfully!!
One thing, once exported to excel, the sizes of each row are huge, about 2 inches tall. just a minor thing, nothing to stress about (for me at least, another thing for my employer, haha) is there a way to adjust settings while exporting,? maybe color of rows and what not?

Thank you so much for the help, good to see this forum's members actually helping out newbs!

Connor
 

Users who are viewing this thread

Back
Top Bottom