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 0 reply threads
  • Author
    Posts
    • 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 0 reply threads
  • You must be logged in to reply to this topic.