Oracle Applications Export to Calc instead of Excel

[Geetar28]

This post is from 2004, but I can't find any newer info. about this issue. Can you export a file from Oracle (which comes as a .tsv file) straight into Calc. Just as the original poster explained, this can be done easily with Excel. But I cannot find out if this has been resolved in newer versions of OpenOffice.

Anyone have any new info?

[Villeroy]

Well, a tsv file might be nothing but plain text, right?
There is much more than one way to import or link text data.

More importantly, you can connect OOo to a wide variety of database servers directly, link to the contained tables, create queries, input forms and reports in Writer and Calc.

All this used to work in 2004 as well. This topic was a very different one.
Many applications use an installed copy of Excel to let it produce valid xls files where these apps dump their data into. Once you uninstall Excel, those apps can not do this anymore.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

[Geetar28]

Yep there are many ways to import data. I'm looking for one way in particular (as was the orignal poster). The fact that OOo connect directly blah blah blah..doesn't really matter to this case.


Not sure why you think this is a very different topic...here's what the original poster stated:

In our organisation, we use Oracle Applications, which provides an "Export" option to export queried data to Microsoft Excel. This "Export" action downloads the data to the local PC as a text file with a MIME type of "tab-separated-values."
In the Windows registry, MIME type "tab-separated-values" is defined to correspond to the ".tsv" extension, and to the Microsoft Excel executable.
Consequently, whenever we select the "Export" option from Oracle Applications, the data arrives in a temporary ".tsv" file, which automatically gets imported into Microsoft Excel as soon as the download is completed.


This is exactly the issue I run into. The person that posted the 1st response explained it better than I ever could...and apparently this issue hasn't been resolved.

Can anyone else provide info. about this issue?


Thanks

[Villeroy]

Ah, I missed the point that their "Excel files" are made of plain text.
But then I do not understand what the problem is. Simply open the files in your preferred spreadsheet program, text editor, database whatever.
If this is a question of macro addiction, there are dozends of macros on this forum alone.
I would prefer a simple configuration file which reads the tsv content into any office document without a single line of code.
Unfortunately, this configuration file is called a "Base document" which alienates most users. I never get the point why people do not run away when the see Basic code.

Apart from this, there are dedicated editor for text tables.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org