SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Evangelist Scott.Botkins's Avatar
    Join Date
    Dec 2004
    Posts
    598
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Converting/Importing .MDB to .SQL

    I have a .mdb file that is 63mb. It contains information that needs to be displayed on the web by tables and rows. I'm needing to have it be placed in .sql for mysql so I am able to do what I need it to do. What would be the best solution to do this? Thanks.

  2. #2
    SitePoint Wizard gRoberts's Avatar
    Join Date
    Oct 2004
    Location
    Birtley, UK
    Posts
    2,439
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


  3. #3
    SitePoint Evangelist
    Join Date
    Aug 2005
    Posts
    453
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you installed ADODB ?
    Documentation @ : http://phplens.com/lens/adodb/docs-adodb.htm#ex1

    Create duplicate tables in mysql to store the data, open both databases, use two different connections. One for your .mdb and one for your mysql database.
    From thee it is straight forward processing, read all the records form one table in the .mdb and write the data one record @ a time to your mysql database.
    Computers and Fire ...
    In the hands of the inexperienced or uneducated,
    the results can be disastrous.
    While the professional can tame, master even conquer.

  4. #4
    SitePoint Evangelist ldivinag's Avatar
    Join Date
    Jan 2005
    Location
    N37 33* W122 3*
    Posts
    414
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    use the FREE access (and other dbms) converter from mysql...
    leo d.


Bookmarks

Posting Permissions

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