Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2013
    Posts
    15

    Unanswered: Creating "append to table" type of query in access 2013 web app ?

    Hi,

    I have excel file called "Products" which looks something like this
    -----------------------------------
    ItemNo. Description Price
    -----------------------------------
    1 Tennis racket 100$
    2 Tennis ball 10$

    In my access 2013 web app I have table "Products" which contains same data as Excel file mentione above.

    My GOAL is next: if someone adds new row (no 3) in Excel file "Products", then Data-macro is triggered so at the end,
    table "Products" FROM 2013 Access Web app is updated with new row, like shown bellow.

    -----------------------------------
    ItemNo. Description Price
    -----------------------------------
    1 Tennis racket 100$
    2 Tennis ball 10$
    3 Tennis shirt 110$

    My QUESTION is next: is it perhaps possible, when Excel file is updated with new row, that table named "Products" is automatically updated
    with that new row using data-macro or similar?

    Thanks in advance for prompt reply and best regards.
    Adi

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    It should auto update without a macro.

  3. #3
    Join Date
    Mar 2013
    Posts
    15
    Quote Originally Posted by ranman256 View Post
    It should auto update without a macro.
    Hi ranman256,

    How is that posssible? As far as I know, in Access 2013 web up, you are only able to import Excel data but you are unable to LINK with Excel file..

    Thanks.
    Adi

  4. #4
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    sorry , misunderstood.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •