update 2 linked access tables with an update from an excel file RRS feed

  • Question

  • Hi

    As the title says it, I want to import an excel file into a MS Access table and update 2 tables that that linked by a idref. Can't find anything on that anywhere; Doesn't seem to be able through an update or append query. Any idea ?


    Friday, January 22, 2016 8:55 AM

All replies

  • Hi PierreBr,

    According to your description, you want to insert into access from excel files, and update two tables by id field, does it? Could you please provide a bit more information, such as excel file, access tables column field.

    Best regards,

    Cole Wu

    Saturday, January 23, 2016 7:33 AM
  • Could you be more specific? Are you inserting new data, updating current data and if so what columns in the tables are you updating?

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Monday, January 25, 2016 1:16 PM