I do not see my last reply – Maybe after I previewed my post, I exited – oh well.
I wanted to thank PeterLarsen for your prompt reply.
My problem is fixed – Here is what I discovered
1. I cannot import the column names… you can export them but you have to remove the column names from the csv file before you import. I guess everyone else knows this … I did not not. The data was imported but so were the column names and MySQL did not like it
2. I exported a record set from a database type on a production server, added a column and inserted new data using Oo Calc 2.2 then I saved as csv and went to import the data into the prototype server database. Calc does not show or apparently care what the datatypes are.
Once I matched the data-types to the production database everything went fine.
It just seems a bit weird to discover this on a csv import process. The Good News – I am wiser now and I hope this helps others.
Summary – remove column names on your import csv file and make sure your data-types are correct.
Thanks,
Mr. KimWill
