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 1 reply thread
  • Author
    Posts
    • February 24, 2016 at 2:40 pm #13506
      zenggggg
      Member

      Hi, Can some one tell me, why when I try to import excel to DB by powertool, when I have a ID in excel  ex.67889  data type in excel is general. when I try to import, give me error message saying 67889.00 cannot be import to DB. Why it changes integer to float, even I set it as Integer when I do the import in powertool. Can some one helps?

    • 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 1 reply thread
  • You must be logged in to reply to this topic.