How can I make Excel fetch data from a database automatically when I open the spreadsheet?
Fresh3 days ago
Mar 15, 202650230 viewsConfidence Score0%
0%
Problem
I want to have an excel spreadsheet, that when it opens will automatically populate from a SQL database, using specific queries. Each Workbook would use a different query (or multiple queries). Ideally when it is opened, the connection properties to SQL could be changed. Any idea how to do this?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can I make Excel fetch data from a database automatically when I open the spreadsheet?
Low Risk
Of course. Here are the basics. 1) Create a connection (once) Excel-Data-From Other Sources-SQL Server (this is for Microsoft SQL, but other data sources are available) Enter Server credentials, uncheck "Connect to a specific table" if you wish to u…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix