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?
I would also like to note that I have created few sam topics on links bellow as I would like to receive best possible solution. Thank you for understanding.
http://www.dbforums.com/showthread....-in-access-2013-web-app&p=6641070#post6641070
http://answers.microsoft.com/en-us/...-fa08-4739-bac4-4399c0d518d9?tm=1454616809792
http://www.accessforums.net/showthread.php?t=57922&p=309932#post309932
Thank in advance for prompt reply and best regards.
Adi
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?
I would also like to note that I have created few sam topics on links bellow as I would like to receive best possible solution. Thank you for understanding.
http://www.dbforums.com/showthread....-in-access-2013-web-app&p=6641070#post6641070
http://answers.microsoft.com/en-us/...-fa08-4739-bac4-4399c0d518d9?tm=1454616809792
http://www.accessforums.net/showthread.php?t=57922&p=309932#post309932
Thank in advance for prompt reply and best regards.
Adi