Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I am having trouble finding a way to Export an Excel query into a SQL server. One of my options is to export from SAS to export into excel (Maybe using VBA?) and then using SSMS to export it into the server. Ive tried the export directly into SSMS but am running into the Ace.OLEDB not provided error.
If there is a VBA code to connect to the two softwares thatd be awesome, if not what else can i do?
Export it using Dax Studio.
--Nate
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 7 | |
| 4 | |
| 3 |