How does excel get data from external sources such as SQL Server?
I'll answer
Earn 20 gold coins for an accepted answer.20
Earn 20 gold coins for an accepted answer.
40more
40more
Works at the International Development Association, Lives in Washington, D.C., USA.
To open a saved query from Excel:On the Data tab, in the Get External Data group, click From Other Sources, and then click From Microsoft Query. The Choose Data Source dialog box is displayed.In the Choose Data Source dialog box, click the Queries tab.Double-click the saved query that you want to open.
2023-05-13 16:08:47
评论(499)
Helpful(122)
Helpful
Helpful(2)

Oliver Jackson
QuesHub.com delivers expert answers and knowledge to you.
To open a saved query from Excel:On the Data tab, in the Get External Data group, click From Other Sources, and then click From Microsoft Query. The Choose Data Source dialog box is displayed.In the Choose Data Source dialog box, click the Queries tab.Double-click the saved query that you want to open.