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.

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.