Help and Support

OL97: No Option to Import/Export dBase, Access, Excel or FoxPro

View products that this article applies to.
Article ID:168783
Last Review:January 19, 2007
Revision:1.1
This article was previously published under Q168783

SYMPTOMS

If you installed a standalone version of Microsoft Outlook 97, the Import and Export Wizard may not include options to import the following data types:
dBase
Microsoft Access
Microsoft Excel
Microsoft FoxPro

Back to the top

CAUSE

The standalone version of Outlook does not install the Open Database Connectivity (ODBC) drivers required to import and export the above file formats. This is also true of the small business addition of Office97 when you install each program separately.

Back to the top

RESOLUTION

To import from these sources, you must install the ODBC drivers provided in the Data Access Pack of the Microsoft Outlook 97 CD-ROM ValuPack folder.

Follow these steps to install the appropriate converter files for dBase, Access, Excel and FoxPro:
1.Quit all Office programs.
2.Using Windows Explorer, double-click Valupk8.hlp in the ValuPack folder of the Outlook CD-ROM. This opens the ValuPack help.
3.In the topic "What do you want to know about?" click "Data Access Pack."
4.Follow the instruction to install the Data Access Pack.

Back to the top

MORE INFORMATION

If you do a complete installation of the standalone version of Outlook, by default the Import and Export Wizard provides support for importing the following file types:
Comma Separated Values (DOS)
Comma Separated Values (Windows)
Lotus Organizer 1.0, 1.1
Lotus Organizer 2.1
Schedule+ 1.0
Schedule+ 7.0
Tab Separated Values (DOS)
Tab Separated Values (Windows)
If you do a complete installation of Microsoft Office 97 Professional, by default the Outlook Import and Export Wizard provides support for importing the following file types:
Comma Separated Values (DOS)
Comma Separated Values (Windows)dBase
Lotus Organizer 1.0, 1.1
Lotus Organizer 2.1
Microsoft Access
Microsoft Excel
Microsoft FoxPro
Personal Address Book
Schedule+ 1.0
Schedule+ 7.0
Tab Separated Values (DOS)
Tab Separated Values (Windows)
Note: The Typical installation of Outlook and Office do not include the Lotus Organizer converter files.

For more information on Office 97 ODBC driver installation, please see the following article(s)in the Microsoft Knowledge Base:
156835 (http://support.microsoft.com/kb/156835/EN-US/) OFF97 : Complete Setup Doesn't Install All ODBC Drivers
161613 (http://support.microsoft.com/kb/161613/EN-US/) OFF97 : Files Installed with the Data Access Component
162714 (http://support.microsoft.com/kb/162714/EN-US/) OFF97 : Files Installed with the Data Access Pack
For more information on all converters included with Outlook, please see the following article in the Microsoft Knowledge Base:
158084 (http://support.microsoft.com/kb/158084/EN-US/) OL97: Converters Included with Outlook

Back to the top

APPLIES TO
•Microsoft Outlook 97 Standard Edition

Back to the top

Keywords: 
kbinterop kbprb KB168783

Back to the top

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.