Forum Discussion

Razorking's avatar
Razorking
Copper Contributor
Sep 06, 2023

SQL Database/Table to Excel- Read-Only

Excuse me for what might be a dumb question. I am trying to make certain that I am clear in my understanding of something. We have a SQL Server database that is used by our ERP system. I would like to link tables to Excel files. However, I want to be sure that users cannot write back to the SQL database/tables. I don't want adding, changing, deleting records in SQL from Excel.

 

Can any of these things be done through Excel when connecting to a SQL Server database?

 

Thanks!

Resources