Forum Discussion
Razorking
Sep 06, 2023Copper Contributor
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!
2 Replies
Sort By
- olafhelperBronze Contributor
I would like to link tables to Excel filesRazorking , a table is a physical object in a database, you can "link" it to anything/anywhere.
You can write a view with OpenQuery command to query the Excel file content.
- RazorkingCopper Contributor
olafhelper Thanks.