SQL to Excel without direct access to SQL-server

[Mufflon]

Hi! I hope this is the right forum for this question.

I have spreadsheets that I want to share with my clients that fetch data from an SQL server. But to update this data require login credentials to the server, and I don't want to give my clients direct access to the server, even if the account is read only etc (or my IT-department won't let me do this ). Is there a way, perhaps a built in way in Excel (or some other solution) that lets you connect the Excel spreadsheet to the SQL-server using some "intermediate"-account (to increase safety etc)?

I'm such a beginner at this, so any tips/links/solutions will be very appreciated!

Regards,
Kim

 

[Johnny C]

It depends on how much data you have, but you could use Access to suck the data out of SQL-server and use Excel to interrogate Access

 

[Mufflon]

It depends on how much data you have, but you could use Access to suck the data out of SQL-server and use Excel to interrogate Access

Thank you! Will look into this

Have a great weekend!