I am creating a program which need to create an excel worksheet on a VB form
and then I need to
embed (?) this sheet into a table in access. I'm good to getting the XL sheet
on the VB form (VB 6 by the way) and I know how to manually add an OLE object
to a table in Access, but how do I code for this so that when someone click's
'ok' on the form after pasting in data to the excel sheet on the VB form,
the program will link that datasheet to the table in access??

Any tips, clues, etc are greatly appreciated.