I have a datasheet (within the frame of a larger form - for presentation purposes).
I may filter the 20,000 rows in the datasheet down to a couple of hundred (using standard Acess Datasheet functionality).
My Question Part One: What is the best (with easy VBA is poss) way to export the (filtered) contents of my datasheet to Excel.
My Question Part Two: I will want to expand the export to include other (related) data other that what is displayed on the datasheet. How do I do this (via a query I presume)