Can you pull Excel data from an external (and dynamic) .csv file?
Fresh3 days ago
Mar 15, 202676072 viewsConfidence Score0%
0%
Problem
I've got a script that outputs a number of performance metrics for a computer into a .csv. The Excel does a basic stats check for standard deviation, etc. I realize you can import .csv files into Excel, but what I'm trying to do is read that data dynamically into my Excel model without having to re…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Can you pull Excel data from an external (and dynamic) .csv file?
Low Risk
Easiest way of doing it is to import the Data into Access or SQL Express, and then use the Data Connection features and functions in Excel. After the initial setup, all you would have to do is click Refresh All and it will pull the the data and reca…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix