SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: ACT DB to MySQL

  1. #1
    SitePoint Enthusiast
    Join Date
    May 2008
    Posts
    38
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ACT DB to MySQL

    I'm trying to help the company I'm working for move away from the ACT by Sage program. Does anyone know of an easy way to convert the DB spit out by ACT into mySQL so I can import the data and start playing w/ it with PHP?

    For once google was of no help to me...

    Thanks.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,340
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    if it can generate a CSV file, you're golden

    look up the LOAD DATA INFILE command in da mysql manual
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,653
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Fair warning: ACT was designed as a proprietary product to keep users locked into ACT. Good luck.


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
  •