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

importing double from msaccess

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications importing double from msaccess

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #14304
      Shadow
      Member

      You can create an sql script file for the job and choose “Use a query…” option instead of copying the tables.

      By the way, why do you have to import the same table that often?

    • #14305
      strimmerboy
      Member

      Thanks… I'll try out the script.

      The reason for frequent updates is that we have a legacy system which we haven't yet fully migrated from Access2000. As a result we need frequent updates to the live mySQL database. I'm currently moving everything over to a mySQL/PHP interface, so I don't want to waste too much time on an elegant solution to getting the data out of Access.

      Thanks again for the script tip

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