SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Microsoft Access DB to MySql

    I'm a newbie. I'm very familiar with Access. I'd like to load an Access table into my MySql datbase at my webhost.

    Can someone explain step by step instructions on how to do this? I'm using MySql version 3.23.54.

    Thanks.

    jlsohio

  2. #2
    ********* Member website's Avatar
    Join Date
    Oct 2002
    Location
    Iceland
    Posts
    1,238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think you can save your tables as CSV right ? (try 'save as' -> CSV (.csv)) Then you can use one of many csv importers, a good one is here.
    Then it is pretty streightforward, you simply select the .csv file, select what is used as seperator (you usually choose when you save it in access in this case, I recommend using ; ). And then you hit Insert or something like that and it is there...

    Hope this helps
    - website


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
  •