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

export to csv –want separate columns

forums › forums › SQLyog › Using SQLyog › export to csv –want separate columns

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • August 30, 2004 at 9:25 am #16235
      1kyle
      Member

      Found the answer.

      1) Export your data as CSV

      2) instead of opening EXCEL direct rename the file to a .TXT file.

      3) Open the file in excel as a TXT file.

      4) Excel will then prompt saying This is a delimited file etc.

      5) Chose the delimited option

      6) He Voila — your data is in nice columns.

      Cheers

      everbody

      -K

    • August 30, 2004 at 11:04 am #16236
      Shadow
      Member

      SQLyog calls the export file CSV even if the field separator is not comma. Try exporting to CSV format with comma set as separator and then it should work as expected.

    • September 7, 2004 at 1:27 pm #16237
      sjs
      Member

      A Newbie Question:

      What are the specific options needed for export to Excel?

      export1.gif

      And what options should be set?

      export2.gif

      Thanks

    • September 8, 2004 at 9:48 am #16238
      Shadow
      Member

      Minimum requirement: fields separated by ',' and lines terminated by 'rn'. Escape characters depend on your data (I use none). It might be useful to add column names to the export file as well.

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