![]() ![]() In the Query Wizard, expand the node for the table you would like to import into your spreadsheet.Select the option to use Query Wizard to create/edit queries. In Excel, open the Data tab and choose From Other Sources -> From Microsoft Query. ![]() You can then work with live Excel Online data in Excel. Getting Started also guides you through executing SQL to worksheets and ranges. See the Getting Started section in the help documentation for a guide. ![]() You use the OAuth authentication standard to authenticate to Excel Online. Otherwise, leave this blank to connect to a production account.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |