Tuesday, March 27, 2012

How to convert .rpt files to .xls

Friends,   It is great problem when we need .rpt files in .xls.  Sometime back I had received .rpt files from Punjab National Bank as Bank Account Statements for a particular account.  I had tried to convert in excel, but after devoting 4 hours, I got fail in conversion. 

             In last I tried following steps and got success. 

  1. Open .rpt file in Notepad.
  2. File Save as in .txt file (as shown in above picture)
  3. Open with  .txt file in Microsoft Excel.
  4. Option "Text to Coloumns" > Fixed >Finish. 
  5. then Save File in excel. 

Intense Debate Comments