Having a spot of bother (or rather a right load of old stress and grief) exporting a table to excel.

I can get VB6 to open Access, and even get the right db open (using OpenCurrentDatabase) but can't seem to figure out how to select a table and then export that table to an Excel 97 workbook. Would be awfully grateful, and I'd give you ten points and a gold star thing.