asked on

Read Azure data from Excel spreadsheet - limit users too

I have azure database with list of data in table say called Table1
I have spreadsheet too
I want to populate spreadsheet with data in Table1.
However only certain users should be allowed to do this. I don't want everyone with the spreadsheet or everyone who knows database location to be able to get data obviously
I can use the excel import data however Azure firewall needs configured to allow access which isn't practical as user IPs change
I only want say my users A,B,C to get data not everyone...
I wonder if need to have web service or something instead of direct database call if so how, or is there other method . Thanks

crystal (strive4peace) - Microsoft MVP, Access

> "However only certain users should be allowed to do this. I don't want everyone with the spreadsheet ..."

are you SHARING the same Excel file with multiple users? This is a no-no. Excel is not a multi-user application. Each person needs to have their OWN front-end. In this case, the front-end would be the Excel workbook that is linked to shared data.

You don't need a web service, just the connection information.

rwallacej

ASKER

Each user will have own COPY of the excel file so they can do their own work on it.
What I need is ability for each user on the own copy of their spreadsheet to update sheet front data in azure database

ASKER CERTIFIED SOLUTION

crystal (strive4peace) - Microsoft MVP, Access

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial