Import the Text file into Excel.


--
Regards
Dave Hawley
www.ozgrid.com
"Marsh" wrote in message
...
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