Hello,
I have filled my spreadsheet with 200 rows with 20 colums of data. The columns have text, date, currencies, exchange rates, numbers, formulas, percentages, address, phone #, zip code, email, web address, I have filled the data on different computers, us and french (the date formats are sometimes different 20-4-89 and 4/20/02 ; numbers are 15,86 and 15.86 ; Rene and Rénà) It is a mess. I want to use my spreadsheet data to create a database. I have managed to create a table and tried to customize it with Field type INTER, Decimal, VARCHAR,… When I copy the spreadsheet and paste it into the table, errors messages show up such as “Wrong data type:java.lang.NumberFormatException:Character , is neither a decimal digit number, decimal point, nor “e” notation exponential mark.” I have tried to use Tools and autocorrect options, I have highlighted the column and use autocorrect with replace “,” with “.” but nothing happened. The reason I want to transfer the data into a database is I want to be able to print each Row’s info on a single Paper. Eventually I would like to use this data for a Website. I am asking for some guidance and what is the most efficient way to go forward to build the most solid, versatile cross platform database. Many thanks
Hello,
You need to not “have a mess”. This does not bode well for databases. You need to get all data corrected if the database is to be meaningful at all. You cannot mix or easily fix number formats and regardless of display formats, dates are always stored in YYYY-MM-DD format. There is no easy ‘fix’ for this. Yes, you can possibly set all fields to VARCHAR, but that is still going to leave you with many problems.
You also need to determine what database you will be using. Since discussing a Website, this is not something for the HSQLDB or Firebird embedded databases which ship with LO. You need to research this depending upon your specific needs.
Thank you very much for getting back to me with your insights. I am diving into more research. Regards