Appending one or more rows
Posted: Thu Sep 12, 2013 6:29 pm
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.
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.