Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: How can i migrate data from MDB to Mysql?

    Hi,

    My old database is MDB and i wanted to migrate some of column in new mysql database.

    MDB table and Mysql table are not identical.

    example:: MDB_Table

    Name Lastname age SSN SEX
    Ron Pat 20 123-23-1234 M
    Mon Bat 32 123-12-1234 F


    Convert to Mysql table like:MYSQL_Table

    Name SSN DOB
    Ron 123231234 Null
    Mon 123121234 Null

    SO i need to change datatype too.see SSN need to be changed mean need to discard -.

    Please help me out.

    So how can i migrate this data from mdb to mysql?

    Thanks.

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    Can you export your MDB data to a text file?
    Create the MySQL table the same as the MDB file and then you can use the ALTER TABLE statment to rearrange or drop the unwanted columns.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •