468,107 Members | 1,301 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

Embed spreadsheet in Access Table programmatically

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
Mar 27 '06 #1
0 1278

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Stan Brown | last post: by
3 posts views Thread by Brooke | last post: by
3 posts views Thread by D.Stone | last post: by
2 posts views Thread by franc sutherland | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.