Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: Access ---> MySQL

    Im working on a project for my work and they use a program called Lab Manager which is like a case/billing system for a dental laboratory and the program is made from Access. I am wanting to design an addon to lab manager which takes information from the database and pulls it into an online account system.

    So basically im asking would it be easy to pull data from an access database using mysql?

    TIA

  2. #2
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    Its faster and easier to export directly from MSAccess, as a batch job, using the myODBC driver. But, if you want the process automated, I suggest creating a VB6 frontend that reads the desired records via SQL (maybe selected by date), using ADO and the Jet driver, and writes the selected records to mySQL using ADO and the myODBC driver. Slower, but with much more control.

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    What about creating a online management system that uses access.. would that be alot easier?

Posting Permissions

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