importing data from Lotus Approach

G

Guest

My company has been using Lotus Approach to maintain a database of client records.We currently have about 19000 records in the database but have been having problems with Approach so have decided to switch to Access .We don't have much technical knowledge and are wondering whether it's possible to transfer the data from the existing Approach database. The thought of starting from scratch and keying in all the records again doesn't appeal! Any advice would be greatly appreciated
 
V

Van T. Dinh

I am not sure whether you can import into Access directly
from Approach but if it is not possible, you can export
Records from Approach to a file format such as Excel or
CSV and these files can be imported into Access. I did
this once about 4 years ago and I think I used Excel file-
format.

You will most likely will have to create Forms / Reports /
etc... from scratch.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
My company has been using Lotus Approach to maintain a
Click to expand...
database of client records.We currently have about 19000
records in the database but have been having problems with
Approach so have decided to switch to Access .We don't
have much technical knowledge and are wondering whether
it's possible to transfer the data from the existing
Approach database. The thought of starting from scratch
and keying in all the records again doesn't appeal! Any
advice would be greatly appreciated
 
G

Guest

Van, thanks for that, I'll give it a go,
all the best

----- Van T. Dinh wrote: -----

I am not sure whether you can import into Access directly
from Approach but if it is not possible, you can export
Records from Approach to a file format such as Excel or
CSV and these files can be imported into Access. I did
this once about 4 years ago and I think I used Excel file-
format.

You will most likely will have to create Forms / Reports /
etc... from scratch.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
My company has been using Lotus Approach to maintain a
Click to expand...
database of client records.We currently have about 19000
records in the database but have been having problems with
Approach so have decided to switch to Access .We don't
have much technical knowledge and are wondering whether
it's possible to transfer the data from the existing
Approach database. The thought of starting from scratch
and keying in all the records again doesn't appeal! Any
advice would be greatly appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Approach to solving a query problem 1
Can I import Lotus Approach into Access 2003? 1
Lotus Approach to Access - "find" function 4
Linked Lotus Approach file showing incorrect characters 2
Importing Lotus approach Database to Microsoft Access 2002 1
How do I copy email addresses to bcc from an outside database? 1
Get Data from Lotus Notes Database into Excel 1
importing databases from Lotus Approach to Access 1

Top