Creating "append to table" type of query in access 2013 web app? (1 Viewer)

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

Is it possible to link Excel file with my Access 2013 web app? As far as I know, I were able only to import Excel data and that is it.. That is why I am looking solution via Data-macro.

Thanks in advance.
Adi

Unfortunately, this is not possible at the moment. You are able to import from Excel into Datasheet views or into data sheets in the Access App but there is no way to automate this.

An ideal scenario would be to have a data macro which ran periodically to read an excel file and append any new rows - neither of these actions are possible (i.e. auto running DMs or reading external files in a DM.

I have suggested both of these features on Access User Voice, a site for making and voting for suggestions to Access (one page for Web Apps and another for Desktop) - here's a link:

http://access.uservoice.com/forums/321915-access-web-apps

Get voting and making suggestions!!


Julian