Want to display entire excel sheet inside ms access form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
What are best ways to display an external excel file inside the ms access
form.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Table match or lookup or other method 0
queries written inside MS-Access are getting deleted 4
Browse button for access form 1
Array with excel sheet inside (need 2 code rows please) 3
MS Access Sub form display with all entries 1
How can i Secure my project 4
Excel How to Fix Damaged Excel File That Won't Open? 3
Microsoft Works to Microsoft Office 6

Back
Top