Results 1 to 8 of 8
  1. #1
    apoorv is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    7

    How to embed excel file into Microsoft access database


    How to embed a Microsoft excel file into Microsoft access database.

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    What do you mean by embed? Import it as a table?

  3. #3
    apoorv is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    7

    embedding excel workbook in access

    I have an excel model. the input spreadsheet in the same are linked with the query output in Microsoft access. is there some way by which the excel spreadsheet can be embedded in access?

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    I see what you mean. You want to view and manipulate the excel sheet from within Access. The easiest way is to have a form in design view, click on "unbound object" and click anywhere in the form. The wizard will pop up and you can choose "create from file" and choose the excel sheet. It will display it in the form. Double clicking on it should allow modification. For further customization, read up on OLE Objects and you can manipulate them in VBA.

  5. #5
    apoorv is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    7

    the excel attachment

    thanks for your help. the excel attachment opens in design view not in the form mode.

  6. #6
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Make sure you enable it in the properties. It opens in form mode as well for me.

  7. #7
    apoorv is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    7
    thanks for your help. job done

  8. #8
    alihassan is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    lahore
    Posts
    8
    I have added unbounded object in form and choose the "Create from file" done this and changed the property "Enable" to "Yes" Excel sheet attachment opens in "Design view" and "Layout view" not in the form mode.

    I am using MS Access 2010 Window 8.1 pro..

    Thanks in advanced.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Corrupted Microsoft Access Database
    By segnosaur in forum Access
    Replies: 3
    Last Post: 10-06-2011, 12:22 AM
  2. Replies: 1
    Last Post: 11-11-2010, 11:56 PM
  3. Replies: 6
    Last Post: 10-30-2010, 08:42 AM
  4. Replies: 3
    Last Post: 06-22-2010, 07:49 AM
  5. Replies: 0
    Last Post: 09-18-2009, 07:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums