Share via

Importing a Lotus Approach database into Access

Anonymous
2013-03-21T22:00:42+00:00

I need to import a Lotus Approach database into Access.   According to Acc2000 article it states that I need to import Lotus into a file format that is compatable with Access.  How do I do this?  I know how to import into Access once the file in recognized by Access.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2013-03-21T23:03:57+00:00

    You'll be able to get the data into Access if you can first export it from Approach into a compatible format - Excel spreadsheet, dBase file, comma-separated-value text. However, the user interface (how Approach displays the data and allows you to search) is utterly different between the programs and will have to be built from scratch.

    8 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2013-03-21T22:41:21+00:00

    I need to import a Lotus Approach database into Access.   According to Acc2000 article it states that I need to import Lotus into a file format that is compatable with Access.  How do I do this?  I know how to import into Access once the file in recognized by Access.

    Actually is says

    "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.  "

    That means from the Lotus Approach application, export the data into something Access can wotk with likedBASE, Excel or CSV files.  Access cannot work with the Lotus Approach data directly.

    4 people found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-04-01T22:44:27+00:00

    what I did I made a new worksheet in approach with all the fields that I needed, then simple copy and paste into a new excel sheet.  you still need to rename your fields accordingly, but still it is worth it :)

    1 person found this answer helpful.
    0 comments
  2. ScottGem 68,810 Reputation points Volunteer Moderator
    2013-03-22T12:22:16+00:00

    As I recall, Approach used the dBase dbf format. So you can just link to the dbf files or import them.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-03-10T10:48:44+00:00

    Hi there

    I have an old Lotus Approach database I want to extract some emails from!

    I know the process to download them to my PC, however I can't find any software so instruction to convert them to a CSV file so that I can upload them to MailChimp.

    Can anyone help please?

    Many thanks in advance

    Jason

    0 comments