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
    • May 19, 2003 at 8:03 am #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?

    • May 20, 2003 at 2:16 pm #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

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