Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 1 post (of 1 total)
  • Author
    Posts
  • April 24, 2015 at 2:01 pm in reply to: Import Excel Data – Incorrect Values #35323
    fvdan
    Member

    Thanks for pointing me in the right direction.  The Excel ODBC driver makes some quirky assumptions indeed.  I found I was able to change the column data type within my Excel spreadsheet to text explicitly and this solved the problem.  Apparently the driver scans the first 8 rows and if a majority are numeric, it assigns the Double type.

     

    I was able to do a Format Cells > Number > Text on the impacted columns and this forced the ODBC driver to send the right values to MySQL.

     

    Here’s a Microsoft KB article that covers this exact issue:  https://support.microsoft.com/en-us/kb/141284

     

    Appreciate your assistance!

  • Author
    Posts
Viewing 1 post (of 1 total)