Evening John.
What you say below means that marketing should/could mention the fact that the Excel files created can be loaded by Libre/Open Office as well as Excel.
Cheers,
Norm. [TeamT]
Sent from my Samsung Galaxy Note III - powered by Three
Evening Rich,
Apologies for the LO thing then. I am sure I read recently that it had been updated and could now handle some really huge files.
I need to check again to be sure I didn’t dream it!
I think there is a law against Notepad …
Cheers,
Norm [TeamT]
Sent from my Samsung Galaxy Note III - powered by Three
Notepad
Notepad++ is the king for all free editors. And your case can be opened with N++ like a charm.
But if you ever need to edit huge files (20 GB and larger) then UltraEdit is mine recommendation.
Hi Rich,
ok, I checked. Libre Office is like Excel in that (from 3.3.3 onwards) 1 million rows is all that Calc can import. However …
Base, the database system which I think is now based on my other favourite database, Firebird, is able to import more than 1 million rows from a CSV. That might be helpful in some way.
forum.openoffice.org/…/viewtopic.php;t=23260
The link above is a tutorial on using Base to import CSV. Given that your Auditors cannot even import a CSV delimited file, I doubt that getting them to use a database would be a win-win situation, but you never know.
Perhaps yo can import it into Base and then export it back out as a Calc spreadsheet (subset) and from there, give them the Excel file they (think they) need.
Maybe!
Cheers,
Norm. [TeamT]
And you can use it as a toad lite using steps in this blog 
www.toadworld.com/…/using-notepad-to-execute-oracle-sql.aspx