Excel 2007 Pivot Tables

[Marsh]

1. How can I create a Pivot Table from a text file, downloaded from a
mainframe database? I have been told this could be done in previous versions
of Excel.
2. If I get a new text file each day, how can I refresh the existing Pivot
Table, without the necessity of recreating

Thank you very much
Marsh

 

[ozgrid.com]

Import the Text file into Excel.