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

Access97 Date/Time -> varchar(25)

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Access97 Date/Time -> varchar(25)

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 26, 2003 at 6:37 am #7722
      kelvinq
      Member

      spent hours looking for a converter Access to mySQL

      yog is the first one that actually seems to work OK but

      import from Access97 [win98 myODBC ] to mySQL

      Access Date/Time goes to varchar(25)

      the data is there in this format: yyy-mm-dd hh mm ss

      so I goes in with MyFrontEnd (thankyou Hubert Denkmair) and change fields to DATETIME where necessary

      -this fixes this problem

      so if yog could do this automatically it would be Terrfic instead of merely Great

    • February 26, 2003 at 2:12 pm #13822
      Ritesh
      Member
      Quote:
      import from Access97 [win98 myODBC ] to mySQL

      This is happening because the ODBC driver for Access returns SQLyog the information.

      You can change a COLUMN datatype, by clicking on the Transform BUTTON in Select Table(s) box of the ODBC Import Wizard tool.

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