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

Uploading Access Files

forums › forums › SQLyog › Using SQLyog › Uploading Access Files

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 10, 2003 at 9:59 pm #8094
      mchenrycounty
      Member

      I have create a database, and I have a table within that database, with information, id, fname, lname, etc..about 12 columns. I would like to import into a database in access into the MySQL table. Any suggestions.

      And then once I have them up there, and I add more, how do I keep from adding duplicates?

      Thanks

    • July 11, 2003 at 6:54 am #14679
      Shadow
      Member

      ODBC import is the solution (Tools menu). Creating indices (primary key or unique) will prevent you from adding duplicate entries. Besides, you can write your own query which will import those records only that you specify!

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