ACT! has a propietary database. You can try seeing if there is a driver to connect to an ACT! database and install that driver (creating an ODBC type connection using that driver) and then link the tables into Access using the ODBC connection. Finding the driver might be tricky though. We didn't go with ACT! because it had no ability to connect with it in the older versions. You can check to see if Prograsive has such a driver - their's is an ODBC replacement. Otherwise anyone with moderate MSAccess skills could design an ACT! clone in-house (limited version). I'd also download the latest MDAC and hope a driver is in that (but doubtful) You'll most likely have to see if you can get it from ACT! itself. They don't like others to see behind the scenes and their structure (same with Quickbooks).
Otherwise, with the newer versions of ACT! you can export most of the data into a csv file. I would check into the ACT! command line parameters and see if you could automate this procedure (using task schedular to execute the vb script or bat file to do this) and then either import into MSAccess or just link to the table(s).
Last edited by pkstormy; 06-07-09 at 22:43.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)