Exporting Datasheet

[Guirg]

Hey All

I have a data sheet as a subform and have been asked to export the data back out... is it possible to export data back into excel? if so can the data being exported be:
1) only whats been filtered
2) have the ability to select what fields will be exported

Cheers

Tim

​

 

[MStef]

Hello Tim!
Look at "DemoQrytoExcA2000.mdb" (attachment,zip).
Open Form1 and try.

 

[Guirg]

would love to but no can do on the work comps ... could u post some code?

 

[Guirg]

Legendary! thanks for that