General discussion

  • Creator
    Topic
  • #2091282

    Access OLE link to Excel

    Locked

    by jmossburg ·

    I have a user that wants an Access (2K) table to be updated any time a row is added to an Excel spreadsheet. Add a row to Excel, have a row added to an Access table with some of the data from Excel. Cascading changes on update to Excel would be nice, but is not required. Has anyone done such a thing?

All Comments

  • Author
    Replies
    • #3879783

      Access OLE link to Excel

      by dklippert ·

      In reply to Access OLE link to Excel

      You can Link to an external Excel table. Changes in Access will change the spreadsheet and the other way around. Choose Table>New and Link.

      • #3879758

        Access OLE link to Excel

        by jmossburg ·

        In reply to Access OLE link to Excel

        Tried that approach, unfortunatly the Excel sheet cannot (political, not technical reasons) be modified to add the additional fields that are added to the Access table.

    • #3879733

      Access OLE link to Excel

      by dklippert ·

      In reply to Access OLE link to Excel

      How about linking and then combining both tables with a query?

      • #3889703

        Access OLE link to Excel

        by jmossburg ·

        In reply to Access OLE link to Excel

        Ended up redesigning the system to eliminate the Excel table. Thanks.

    • #3889702

      Access OLE link to Excel

      by jmossburg ·

      In reply to Access OLE link to Excel

      This question was closed by the author

Viewing 2 reply threads