The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

Pivot Tables are the “defined as tables” spreadsheets that the Pivot Table tools use to create custom reports for both flat-file and multi-file (relational) databases.

Create a Flat File Connection Manager Right-click in the connection manager design surface, which is below the main design surface. Select "New Flat File Connection Manager" from the context menu.