Microsoft KB Archive/302448

= ACC2000: How to Import or Link Files from a Lotus Approach Database into Access =

Article ID: 302448

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q302448



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
This article explains how to import or link Lotus Approach (.apr) files into Access.

Note that you can import data into either an Access database (.mdb) or an Access project (.adp), but you can link data only to an Access database.



MORE INFORMATION
Before you can import data from Lotus Approach into Access, you must first export the data into a file format that is compatible with Microsoft Access.

Then follow these steps to import the data into an Access database or an Access project, or to link the data to an Access database:
 * 1) Specify which procedure you want to perform:
 * 2) * To import data, on the File menu, point to Get External Data, and then click Import.
 * 3) * To link data, on the File menu, point to Get External Data, and then click Link Tables.
 * 4) In the Files of Type box, click the file format you used when you exported the Lotus Approach data.
 * 5) Browse to the drive and folder where the exported file is located, double-click the file, and then follow any on-screen instructions.

For additional information about compatible Open Database Connectivity (ODBC) drivers, click the article number below to view the article in the Microsoft Knowledge Base:

208689 ACC2000: List of ODBC Drivers Installed by Access, Office, and MDAC

Additional query words: inf

Keywords: kbhowto kbinterop kb3rdparty KB302448

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.