inserting worksheet into an OLE field with VBA
I'm trying to embed an Excel worksheet into an Access database in an OLE field. The operation is generated in the Excel workbook, through VBA. I have set up an ADODB connection to the database, but I don't know how to handle OLE fields. Can anyone, please tell me how to insert the worksheet?
And how to extract, afterwards, the worksheet from OLE field?
Would linking be a better solution?