importing data base files from Lotus

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Larch - 11 Jun 2004 22:05 GMT

I have a large data base in Lotus. I would like to
import the whole db into Access. I frequently open an
individual file in Lotus and send it as an e-mail
attachment to business associates. Fewer and fewer of
them have the ability to open these files as they no
longer have Lotus. Can I just import the whole db and
then use it in Access????

Reply to this Message

John Nurick - 12 Jun 2004 21:17 GMT

Hi Bob,

Do you mean Lotus Approach or Lotus Notes, or Lotus something else?

Either way, it's almost always possible to export the data from there
into a form that Access can import (e.g. CSV or .dbf files), but all the
functionality of the database (forms, views, reports or whatever) will
have to be re-created using Access's own tools.

As far as I know, most Approach databases keep their data in .dbf files
that Access can import directly.

A different approach to your problem would be to stick with your present
database and, when you need to send data to an associate, export it in a
common format such as a CSV or .dbf file and send them that.

>I have a large data base in Lotus. I would like to
>import the whole db into Access. I frequently open an
[quoted text clipped - 3 lines]
>longer have Lotus. Can I just import the whole db and
>then use it in Access????

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message