?
Solved

ACT 4.0 conversion to Outlook 2003 - Please HELP!!!

Posted on 2005-03-10
3
Medium Priority
?
234 Views
Last Modified: 2010-08-05
Hi,

  I am trying to extract the Calendar & Contacts from an ACT 4.0 Database and import them into Outlook 2003.  
The built in import tool is not working, and I have not been able to find a third-party program that supports anything below
ACT 6.0.   Please advise!  THANK YOU VERY MUCH!

0
Comment
Question by:dpctechhelp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 
LVL 19

Expert Comment

by:Serena Hsi
ID: 13510139
Export the ACT database to a comma-delimited file, then import it into Outlook. Do you have custom fields in ACT?
0
 
LVL 19

Accepted Solution

by:
Serena Hsi earned 2000 total points
ID: 13510205
To export ACT! data for use in another program:

Launch ACT!, opening the database you want to export from.

Click the File menu, point to Data Exchange, then click Export. The Export Wizard opens.

In the File type drop-down list, click Text - Delimited.

To the right of the Filename and location box, click the browse button. The Save As dialog appears.

In the Save as type drop-down list, click either Text - Delimited (*.txt) or Text - Delimited (*.csv).

Navigate to the folder you want to save the file to, then enter a name for the exported file into the File name field. ACT! will create this file for you. Click Save.

Click Next to advance the Export Wizard.

Under What kind of records do you want to export?, enable either Contact records only or Group records only. When exporting to a text-delimited file, you can only export one record type at a time. If you need to export both, first export the contacts to one file, and then export the groups to a second file.

(Optional) To specify the export options:

Click Options. The Export Options dialog box appears.

Under Select field separator, click either Comma or Tab. The default is Comma. The application you will be importing the data to determines which field separator you should use.

Under Do you want to export field names?, enable the Yes, export field names check box if required. This option can be useful for mapping fields when you import into another application.

Click OK to close the Export Options dialog box.

Click Next to advance the Export Wizard.

Under Which contact or group records do you want to export?, click one of the following:

Current record exports only the currently displayed record.
Current lookup exports all the records in the current lookup.
All records exports all records in the database.

Click Next to advance the Export Wizard.

The final page of the Export Wizard allows you to specify the order of exported record fields in the text-delimited file. Modify the field export order or remove fields from the export process as you require. Or, if you previously saved a field map, click the Load Map button.

Note: To ensure a smooth import process into the destination application, it is important that you set up the field order to match the order in the destination application. For example, if you will be importing the text-delimited file into an Excel spreadsheet, ensure you sequence the fields in the same order that they appear in the spreadsheet.

To change the order of fields in the list, click the field name in the list above which you want to insert the field and then click Insert Field. For example, if you want to insert a field above Company, click Company and then click Insert Field. When you click Insert Field, a drop-down list appears from which you can select the field you want to insert. When you insert the field, the field moved from its previous location in the list to the location you specified.

To remove a field from the list, click any field in the list and then click Remove Field. When you click Remove Field, the field is removed from the list and will not be exported. If you remove a field from the list, you can always add it back by clicking Insert Field.

To replace a field in the list, click the field you want to replace. A drop-down arrow appears to the right of the field. In the drop-down list, click the field that you want to replace the active field. The field that previously appeared in that location is replaced with your selection.

(Optional) If you expect to need the field map again, click the Save Map button. In the Save As dialog box, navigate to the folder you want to save the map in, enter a File name for the map, and then click Save. Map files are saved with a .map extension.

Click Finish to begin the export process.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question