Apache OpenOffice Community Forum

Hello,
I wonder if anyone can help me with this small problem:

I know how to import a CSV file into Base, but I have a database that regularly has data added to it.

Is it possible (I tried, but it did not seem to work) to only import the new data and merge them into the existing Base table without always having to import all the data?

Here is how I do my importing:

I use Navicat to get the data out of my online MySQL database and import the data as a CSV and then just import them into Base.

However, I have tried to only import the latest data and then add this to what was already in the Base table, but that did not work.

My gut feeling tells me there is a way of doing this, if I only knew how.

Any suggestions anyone?

Thank you in advance.

No need to fiddle around with MySQL, HSQL and csv. Just connect a Base document to your MySQL database.

Thank you for your reply.
However, that is exactly an issue I had inthe beginning I started using OO, and I have not found a way out of it yet.

Here is what I posted about the problem:
http://forum.openoffice.org/en/forum/vi ... 27#p281827

Thank you again.

Rudolfo is certainly right saying that your database might not be connectable.
So you have these ugly csv files and another database on your local machine.
Is that other database a HSQLDB? (see status bar)
Can you post some typical csv lines copied from an ordinary text editor?

Hi Villeroy,
yes the DB on my machine is HSQL.

I have now started importing as an .xls file, which I open in the spreadsheet and then copy and paste into the DB.

However, still not sure about getting one line out of the online MySQL DB and adding it to the rest of the OO Database.

I attach an .xls file.
(Mind you, it is not in English).

However, still not sure about getting one line out of the online MySQL DB and adding it to the rest of the OO Database.

I think you need access to the machine where the MySQL server is running. The rest is a simple SQL statement according to the MySQL documentation.

Your dates and IDs are invalid. You imported them as text values.

Invalid?
I am getting completely confused now.
Same as for accessing the machine where the MySQL is located, OO won't let me.

Thanks anyway.