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

Importing Excel Or Csv

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Importing Excel Or Csv

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 6, 2007 at 5:03 pm #10368
      revrob
      Member

      I'm checking out sqlyog for some migration jobs, but I can't even get it to import a simple excel or even CSV file yet.

      I'm going through the migration wizard, I created a new DSN (as per previous topics) but when i get to the “Select Tables” screen, none are listed?

      Is there a suggested process for importing CSV or Excel files?

      Thanks for help and any instructions!!

      Rob

    • June 6, 2007 at 8:48 pm #24144
      peterlaursen
      Participant

      You cannot import excel files directly.  But there are two ways to import CSV files.

      1) Create a table with a structure 'matching' the data in the file.   Now you can 'import' from teh table menu or context  Wthis you can import and all sorts of text files with data whetehr comma delimited, semicolon delimited or TAB delimited.

      2) use the Migration Tool.  Define a DSN with the Microsoft text ODBC driver pointing to a specific folder.  Every supported file (type) in that folder will be considered a table by the driver.  If you have problems with that please detail the problems!

      related FAQ's:

      http://webyog.com/faq/28_73_en.html

      http://webyog.com/faq/17_88_en.html

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.