Displaying Excel Sheet inside Access Form

[Hogunyi]

Hello Community,

I have a question about how I can display an excel sheet inside of a Form. (couldn't find similar posts)

I've tried using Unbound OLE Object but it will only show the sheet like an image. Can't scroll or anything.

Is there any way we can at least have scrolling capabilities? (I don't mind not being able to edit the sheet)

Also, if there are ways to display a set range? For example, show only rows XYZ.

I would usually just make the sheet into tables and display data that way, but the sheet is setup in a columnar format.

Thank you!

[ranman256]

Don't.
Just open the workbook in XL via vb.

[apr pillai]

Here is a method that I tried long back, may be useful: Microsoft Excel Power in Access.