470,601 Members | 1,374 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,601 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...

references the correct column, and
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)
rset!FileOLE.Value=form!ExcelObj.Object.Applicatio n.Workbooks(1).Sheets(1)
is valid.

What do I have to do?
Mar 27 '06 #1
0 1339

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
By using this site, you agree to our Privacy Policy and Terms of Use.