Shane,
This could be your lucky day - depending on just how large those text
files are.
Using the embedded Base database engine (HSQLDD) there is support for
working directly with text files. This is support is pretty darn good
and there are a number of examples I can point you to, to utilize it.
http://www.oooforum.org/forum/viewtopic.phtml?t=29915&start=0&postdays=0&postorder=asc&highlight=flat+file
http://www.oooforum.org/forum/viewtopic.phtml?t=25434&highlight=baseball
You will want to look at the user docs at http://hsqldb.org also, they
have a section that covers use of the TEXT table.
From a real world experience I have a site that is using a Base file
and some basic library code to import text data and do some analytics on
it daily, running now since a week after the final release of 2.0. The
only problem that has arisen at the site as been when one of the MIS
developers altered the extraction routine that created the text, and
failed to let anyone know......my user found out over coffee the next
day, I found out before lunch was due.. :-(
Anyway, for me this has been one of the jewles in the Base package.
Shane Johnson wrote:
Andrew,
I don't need multi-user access to the files. I am the only one
using the files. I have to convert large ASCII text files, or Excel
files, into a specified, space delimited, text format for our Business
software. I started using Excel then moved to Access so I didn't have
to split the files into pieces. Now I would like to switch off of
Microsoft. That is why I was exploring OOo Base. Every other
component of OOo I have found easy to switch to but this one, because
of this problem. I will explore Base and MySQL and see what works best.
Thank you all for your advice.
Shane
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
