Forum Discussion

KCDG60626's avatar
KCDG60626
Regular Visitor
3 years ago

Export power query into SQL server

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?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Export it using Dax Studio.

     

    --Nate