Want to display entire excel sheet inside ms access form

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top