We help IT Professionals succeed at work.

Software for Importing text based report

Sometimes my client generate a report in a text format, such as Oracle report.
And the report usually having header in many rows.

and the item on the left hand side usually show once if the next records is below to the same item..

I have many different kind of text based report and i want to find a software import those reports to excel very quick and easily

anyone know any these kinds of report importing software? Thank you!
Comment
Watch Question

Commented:
You can try ACL, www.acl.com, or IDEA, http://www.caseware.com/products/idea.

However, they are not cheap.

I personally have use both.  They are great for working with files in different formats.
Billy MaVice President

Author

Commented:
really? even Oracle text format report can import into excel?
personally use? how much to buy?

Commented:
I believe you can connect to Oracle database using OBDC interface.  You can contact them to get price quotes.

Commented:
Oracle ODBC Connection String
Driver={Microsoft ODBC for Oracle};Server=myservername;Uid=myusername;Pwd=mypassword;
CERTIFIED EXPERT
Commented:
hi
If the "text based reports" are saved in a text file format such as ".csv" or ".txt" then you may find that Ron DeBruin's free excel addin is useful. It is quite flexible & easy to use and can be sourced from his site: http://www.rondebruin.nl/merge.htm

hth
Rob

Explore More ContentExplore courses, solutions, and other research materials related to this topic.