Revised:  06/06/2007

Exporter for ACT! 2005-2007 exports  exports ALL**  ACT! data  from the  Contact, Groups Company, Notes, History, Activity, Sales, Group Membership  into comma or Tab delimited files, an Access database, standard dBase IV  files , a Visual FoxPro database and/or back to ACT! 6.   

**See Server section below for more information.

TXT   All tables are exported in windows standard comma delimited or TAB delimited format.

ACCESS  All tables are exported into an Access database.  The relationships between the tables are setup.

DBF  All tables are exported in dBase IV format with a .dbf extension.  For tables containing memo fields, there will be a .dbt extension which contains the long data fields

DBC  All tables are combined into a Visual FoxPro Database container.  The relationships between the tables are set up.  DBC files can be used with almost any window application through the ODBC drivers.  In the Download area of our web site, you can find information describing how to use this file type.

DBF_Flat  Using the flat file format, all the notes and history records for a contact are combined into a single long field.  This makes importing into applications such as Outlook much easier.  The other tables will be exported if checked but not included in the record.

TXT_Flat  This is the same as the DBF_Flat except the data is exported as standard windows comma delimited text mode.

ACT! 6  Exporter will return the ACT! 2005-2007 database to ACT! 6.  The data returned depends on the Export Server used.  (See below.)

Exporter for ACT! 2005-2007 can use the following export servers:

OLE DB  This is the standard export server that is supplied with both ACT! Standard and Premium.  It does not allow export of Activities, Attachments or Group Membership.

ACT! SQL Instance  You can purchase a utility from Sage that will give you access to the ACT! instance of the SQL server.  This will allow complete access to all of the ACT! data.  This allows concurrent access to ACT! and the Exporter.

Local SQL Server  If you have another SQL server available, you can make a copy of your ACT! database and attach it to this server.  This will give you access to all of the ACT! data.  If you don't have a server, you can download the Exporter with SQL server.  This will install the correct version of SQL for your system.  If you use a SQL server, you do not need to have ACT! on your system.