Press Enter and, in the Select Database and Table box, choose the database you want, then click Enable selection of multiple tables. Otherwise, enter the username and password provided by the database administrator.
In the Log on credentials box, click Use Windows Authentication if you're connecting as yourself. In the Server Name box, enter the network computer name of the computer that runs SQL Server. Your database administrator can provide the necessary information.Ĭlick Data > Get External Data > From Other Sources > From SQL Server. Make sure you know the server name, database name, and which credentials to use when connecting to SQL Server. Here's how you'd import multiple tables from a SQL Server database. You can add these tables to the Data Model in Excel, create relationships between them, and then use the Data Model to create your PivotTable. Import multiple tables from other data sources including text files, data feeds, Excel worksheet data, and more. You can import multiple tables at the same time. Import from a relational database, like Microsoft SQL Server, Oracle, or Microsoft Access. To get multiple tables into the PivotTable Field List: You can immediately build a PivotTable based on related tables as soon as you import the data.
No manual formatting or data preparation is necessary. Each of these tables contain fields you can combine in a single PivotTable to slice your data in multiple ways. What’s different about this PivotTable? Notice how the Field List on the right shows not just one but a collection of tables. And when your data happens to be relational-meaning it's stored in separate tables you can bring together on common values-you can build a PivotTable like this in minutes: PivotTables are great for analyzing and reporting on your data. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More.