Saving OLE Excel to Access table

[cbh35711]

All Hello,

I have an embedded Excel 2007 file on an Access 2007 form. The excel file provides the user interface i need easier than recreating it in Access. Once the user has input the required information, I need the data to be saved in a table.

I have worked with recordsets before, but not exactly sure how to handle this one.



Any advice would be appreciated!

Thanks!

Chris

[cbh35711]

So i still haven't figured this one out. I had an idea. Instead of trying to "read" the embedded excel, i could save it to their computer then import it back. This seems like a roundabout way to do it, but i think it would work.

Thoughts?

Thanks!

Chris