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

Importing from Access – Primary key issue?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Importing from Access – Primary key issue?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 4, 2003 at 3:48 pm #8007
      ekraft84
      Member

      Hey All,

      I'm trying to import an Access DB and when I do, all the field values are shown as being NULL.

      It looks like the mySQL db doesn't have the primary key defined correctly. Could this be causing the problem? How do I set the primary key here?

      Thanks Much,

      Ed

    • June 4, 2003 at 6:28 pm #14456
      Ritesh
      Member

      SQLyog automatically creates column with the correct PRIMARY KEY. Are you getting all columns as NULL?

      Please elaborate

    • June 4, 2003 at 7:27 pm #14457
      peterlaursen
      Participant

      try the other way around

      Export from Access – I never had problems with that. Thereafter u just check indexes and field characteristics (NULL/NOT NULL, BINARY etc.)

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