Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    10

    Angry Unanswered: how to export MySQL table to MSAccess -error: "couldnot find installable ISAM "

    Hello,

    I am trying to export tables from MYSQL database to Access 97.
    am trying to export tables from MYSQL to Access 97.
    I have phpMyAdmin 2.5.6 and I used Export Feature in that.
    I exported tables to csv data
    with CSV options Fields terminated by ;
    Fileds enclosed by "
    Fields escaped by \
    Lines terminated by \r\n
    Replace Null by NULL
    and Saved as a Inventory.csv file on my desktop.

    And then opened a new database and tried to export the .csv file. It asked few questions and left them all with defaults.
    when I clicked Finish Its giving me error "couldnot find installable ISAM"

    Could you please help me why its giving me this error.?
    please please help,

    Thanks,
    Nubee

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Can I make a suggestion, as usefull as phpMyAdmin is there are smarter tools to go from MySQL to Access (and vice versa) - have a look a dbTools (www.dbtools.com.br) fro one. There is a 'professional version', which costs and a slightly brain damaged (less functionality - but plenty for what you are trying to do) free one.

  3. #3
    Join Date
    Jan 2005
    Posts
    4
    Besides dbTools as mentioned by healdem, you may also try Navicat (http://www.navicat.com), they have well developed Export Wizard to export MySQL data directly to Ms Access file. You can even set a schedule for it to run automatically.

  4. #4
    Join Date
    Jun 2003
    Posts
    13
    May I post one more link here - EMS MySQL Manager can do it also
    http://www.sqlmanager.net/products/mysql/manager

Posting Permissions

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