inserting worksheet into an OLE field with VBA
I'm trying to embed an Excel worksheet into an OLE field (Access database) from Excel workbook, with 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?