Reputation: 61
excel csv to mysql-numbers >1000 becomes 1.00
While uploading excel csv to mysql i find that '1000' becomes 1.00 and max value remains 999.99. While uploading same table with microsoft words spreadsheet it is fine but it has limitation of numbers of rows.how i can upload large table to mysql, i have csv data in .text files that has to be converted to .csv
Upvotes: 0
Views: 558
Answers (2)
Reputation: 9425
It might be due to the thousand separator. Make sure that in your CSV, you see "1000" and not "1,000".
Also, see mySQL load data local infile incorrect number format, it might help you out.
Upvotes: 1
Reputation: 8578
The problem is either the formatting in your excel file or the limitations of numbers in your mysql table. Can you upload the file to google docs and show us the query which is used to create the table (alternatively - a screenshot of the table's structure)?
Upvotes: 0
Related Questions
- numbers issue after export mysql data to CSV
- Convert String or Float to Int when Importing a CSV into MySQL
- Problems importing excel data into MySQL via CSV
- Help Importing an Excel File into MySQL using phpMyAdmin
- MySQL prevent decimal field from rounding
- Importing csv file into mysql: Incorrect decimal value: '"0.5'
- import csv file into mysql using phpexcel but leading zeros are removing
- Keep Decimal Place When Importing CSV to MySQL
- Why is my imported data getting messed up in mysql?
- Excel CSV to Mysql Database