| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to convert rpt files to xls
I get reports in .rpt format and I enter everithing manually to excel. Is
there a way to convert *.rpt file to *.xls. 05MAY05 Branch Sales Report AmT/MA2 10.4.4 BHR0002 16:14:21(EDT) REPORTING DATE: 28APR05 PAGE# 1 DIVISION : 1 Community : 12 PROGRAM WN PL SH EX Meadowlands Harness 0.00 0.00 0.00 0.00 This is what I have in *.rpt file and I want to convert to *.xls and keep in seperate cells. I did text to column space and tab delimited and did not work. it seperated everything. |
|
#2
|
|||
|
|||
|
"AV" wrote...
I get reports in .rpt format and I enter everithing manually to excel. Is there a way to convert *.rpt file to *.xls. .... There are ways to parse any text file programmatically, but you might be better off with a product like Monarch. See http://monarch.datawatch.com/monarch-standard.asp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert PDF files to Excel? | Excel Discussion (Misc queries) | |||
| how i convert excel files with images to access | Excel Discussion (Misc queries) | |||
| Prompted to convert the file's text encoding... | Excel Discussion (Misc queries) | |||
| Must convert 500+ xls files to txt (tsv) | Excel Discussion (Misc queries) | |||
| Convert prn files to excel? | Excel Discussion (Misc queries) | |||
Linear Mode
