Huge MYSQL to MSACCESS

Discussion in 'Databases' started by michaelspinks, Jan 17, 2011.

0
  1. #1
    Is there any free application for the conversion? I have at least 600mb of MYSQL to be converted to MYSQL.
     
    michaelspinks, Jan 17, 2011 IP
  2. brian culbert

    brian culbert Peon

    Messages:
    38
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Don't ever do that. Msaccess is not for huge database. I have troubles with msaccess at 20 MB.
     
    brian culbert, Jan 19, 2011 IP
  3. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Access has import tools that can use an ODBC connection.

    Would question why you want to do it however as Access is not designed for massive databases. If your wanting to move from MySQL onto a Microsoft platform for some reason MS SQL Server Express would be a more sensible route than Access
     
    AstarothSolutions, Jan 20, 2011 IP
  4. nuare

    nuare Member

    Messages:
    49
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    28
    #4
    yes, do not use access for huge db, you can use MSSQL Express 2008 R2 free of charge. it allows to have databases up to 10 GBs
     
    nuare, Jan 20, 2011 IP