Want to display entire excel sheet inside ms access form

[Sivanand]

hi,
What are best ways to display an external excel file inside the ms access
form.

 

[Jerry Whittle]

If using Access 2007 you can attach as exteral file to a record.

For older versions try putting it into an OLE field.

If it's just one worksheet that looks like a table, just attach the
spreadsheet as a table.

 

[Sivanand]

Thanks Jerry

I tried with this method, intially part of the excel data is visible in the
screen, to see entire excel I activated the OLE control as In-Process, now
the screen size is different and I cannot able to control the container
control size. Although I can able to set OLE control width/height it i not
applied to the activated container control. Is there any way to set the size
of the Container control size programmatically.

Regards
Sivanand
FTSI, India.