 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / ActiveX Controls / February 2005Excel in Access
Good Afternoon, I have a tab of an excel 2003 spreadsheet that I need to include in an access 2003 report. Is this possible and if so how? I thought I had read somewhere that there was a control to do this? Thanks in advance! Dale You could export the tab into another workbook, start a new table in Access to Import the information into an Access table. Just make sure the column headings are something that the db can use and that your cell formats are consistent. This is how I've always done it. Hope this helps. Snick "Its a matter of semantics -- you call it a drinking problem, I call it my reality exit strategy!" The excel control that you speak of is part of the Office Web Components available from Microsoft office website. The Excel control for the OWC may be embedded in a form to provide Excel like functionality.  SignatureRegards Alvin Bruney [Shameless Author Plug] The Microsoft Office Web Components Black Book with .NET available at www.lulu.com/owc -------------------------------------------------- > Good Afternoon, > [quoted text clipped - 5 lines] > > Dale |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.