I have an access table with a column defined as an OLEObject.
I can drag and drop an Excel file into this column.
I can create a form with an unbound ObjectFrame, and load a spreadsheet into
it with a FileDialog and a little VBA code.
I can even open the spreadsheet from VBA - either directly from the
filesystem or from the embedded object in the form control - and manipulate
the individual Cells(). What I can't seem to accomplish is to load the
spreadsheet into the Access Table.
Neither Google nor MSDN have been my friend here...
Where:
rset!FileOLE
references the correct column, and
form!ExcelObj
references the form control,
form!ExcelObj.Object.Application.Workbooks(1).Shee ts(1).Cells(1,1)
seems to access individual cells properly, yet
rset!FileOLE.Value = form!ExcelObj.Object.Application
seems to save _something_ but it's absolutely not accessible to me (it's
just shown as "long binary data") and neither
rset!FileOLE.Value = form!ExcelObj.Object.Application.Workbooks(1)
nor
rset!FileOLE.Value=form!ExcelObj.Object.Applicatio n.Workbooks(1).Sheets(1)
is valid.
What do I have to do?
--
derek