Does anyone know how to convert a Microsoft Word .RTF file into a Microsoft Excel file? I have tried everything I know and I have no success other than getting everything crammed into column A in excel. Thank you.
Since the document was generated by an automated process, can you use a different layout in CR and format it differently? Preferably, some sort of tab delimited text file format. Or maybe I can show you an easy way to extract it from the database without even using CR?
The report was generated by Seagate Crystal Reports then exported into the format I have which is a RTF file that opens in WORD. I don't have access to the database from which the report was generated. I am famailiar with Crystal because I use it at my business, but I am unable to import the RTF into Crystal, Excel, or anything.
The file is extremely large and the company that sent it to me sent it this way on purpose so that I would be unable to sort/manipulate the data for further analysis. I know it was generated from Crystal bc it says so when I do a properties on the file.
I cannot send the file as it is confidential information. So I guess I'm stuck.