Did you need to convert the Excel file to text or could you read it directly as a database and still get the analysis you want?
Have you considered converting it do a delimited text file or, perhaps better in this case, a file with fixed width columns?
I just convert to test. Tell me about fixed width columns, please. Could be the answer..
In Excel, File, Save As, Formatted Text (Space delimited) (*.prn) - this is the description of the file type in Excel 2010. Look for the .prn extension in whichever version of Excel that you're using.
This is another one of my favorites, as it's one of the few file types that's often exclusively associated to Monarch.
I just started the PDF
10-Dec VR 00004056-001 AA.3120.200 POLICE - EQUIPMENT $1,832.00
10-Dec VR 00004058-001 AA.3120.200 POLICE - EQUIPMENT $11,243.00
10-Dec VR 00004059-001 FF.8320.200 WATER-PUMP-TEST WELLS $6,857.00
AC 33067 00M&T BANK M&T BANK 1/12/2011 $565.50
11-Jan VR 00004252-001 AA.1325.400 TREASURER - CONTRACTUAL $565.50
AC 33213 00M&T BANK M&T BANK 2/9/2011 $3,770.75
11-Feb VR 00004485-001 AA.1325.400 TREASURER - CONTRACTUAL $565.50
11-Feb VR 00004486-001 AA.1325.400 TREASURER - CONTRACTUAL $565.50
11-Feb VR 00004404-001 CL.8160.200 REFUSE & GARBAGE EQUIPMENT $2,639.75[/code]