On 05/12/17 2:48 AM, John Buono wrote:
Hi, I have a problem. I am trying to import a CSV file into a database. I have followed help page but it does not work. I open the CSV file and it opens correctly in a spreadsheet. But then when I copy and paste the rows and columns into the database table, all I get is the last value of the CSV file in the first cell of the database. What am I doing incorrectly?
What you do incorrectly is hard to say, but you could start to copy the data into a new table and see if that works. From there you could check column names and attributes and check if there are any differences. Don't forget that spreadsheets are more forgiving on data inconsistencies than databases. Without more insight into the data structure there is not much more I can say.
John
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org