Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unanswered: Act! 2000 to MS Access 2000

    Is there a way to like to the tables in act from access.. When I try to link I get an error

  2. #2
    Join Date
    Nov 2003

    Re: Act! 2000 to MS Access 2000

    I assume like means link. In that case, there really isn't. There's export/import, or you could extract data from act in an ODBC manner and push it into an Access record.
    strConnect = "Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF; SourceDB=C:\ActTestDB; Exclusive=No;"

    You would do a SELECT query from act (SELECT field1, field2... FROM filename WHERE fieldn=value) Where filename is the name of the DBF file.

    Then do an INSERT query into your Access DB (obviously you would need a separate connect string for the Access DB).

Posting Permissions

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