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

Import Excel Data To Db By Powertool

forums › forums › SQLyog › Using SQLyog › Import Excel Data To Db By Powertool

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • March 10, 2016 at 1:03 pm #35672
      Sibin A S
      Moderator

      Hi,

       

      The value inserted into the table is being returned by your ODBC driver. The number data-type in Excel is SQL_DOUBLE for ODBC Driver. Please refer >> https://msdn.microso…0(v=vs.85).aspx

       

      You can also select the corresponding cell from the excel sheet and right click to select the option  >> Format Cells -> Number – > Text. Doing this will ensure that the cell is treated as a text even if a number is present. Therefore letting us display the text to be displayed exactly as entered.

      Please refer >>   https://support.micr…en-us/kb/141284

       

      Regards,

      Sibin

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.