Problems with quotation marks when importing data from Excel to the Bank (MySQL) [closed]

0

I have an Excel file with a lot of data, the problem is that there is apparently some double-quote data, and when you load that data, all columns are mismatched and therefore the data is populated in wrong (different) columns. I am using DreamCoder to "play" the data in the database. I did not see any double quotes in my Excel file, but I noticed that they started appearing in the database.

apparently the quotes that caused the data to be populated in the wrong places ... I saw in my original excel file and I did not see any quotes in that data.

    
asked by anonymous 13.11.2015 / 14:23

1 answer

1

With the Excel worksheet open, try these steps:

  • Try replacing all double quotation marks "" with any other character as parentheses () or Space,
  • Replace all single quotation marks '' with any other character as () or Space,
  • Check which field delimiter you are using, in the my case, I prefer to use the dot com ; , so I replace all the semicolons ; by commas , ,
  • Do not forget to select the Character Set, if you do not know much about the differences, use UNICODE UTF-8

All this process I do for LibreOffice or OpenOffice, for the easiness at the moment of saving the file .csv

    
13.11.2015 / 21:37