Changing over from Lotus Approach v3 to MS Access

I need some advice on changing over from Lotus Approach v3 to MS Access.  I need to know what is involved on making the data transfer from Lotus to Access and is the easiest way to set up all of the user interfaces (how Approach displays the data and allows you to search and set that up in Access) up in Access?  Is there some kind of software or conversion tools available or will things have to be set up from scratch?

Thank you for your help.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
From scratch, I'm afraid. The data can be exported to 1-2-3, then to Excel, then imported into Access.

See this thread for more information.

Jeffrey CoachmanMIS LiasonCommented:
Unfortunately, the only thing you will be able to bring into Access is the raw table data.

(Make a backup of the entire Approach database system first.)

The best way would be to export all the tables to the Excel format. (or the CSV format)
You may still have to tweak the data types if they don't end up being exactly what they wee in Approach.
See here for info on Access data types:

Then you must rebuild your Forms and Reports from scratch.
Fortunately, Access has a great set of wizards to hep you with this.

If Approach uses SQL as a query engine, then "theoretically" you should be able to copy the SQL and paste it in the Access SQL query designer in Access, then simply save it as a query.

As far as a "Search", guess is that you mean "Filtering"
In the most basic sense, can create a form in Access (for example, ...based on the Customer table), ...then create a combobox (again, using the combobox wizard), ...then select the "Find a record on my form" option.
This will allow you to select a customer from the list, ...then display (filer for) that customer's record only.
Filtering can also mean something like filtering all Customers that live in "China" (Text)", or all Employees with a Department ID of 7 (Number).
his will require (VBA) programming, ...(outside the scope of this basic explanation.)
...But the syntax will be different for text and Numbers:
For example:
me.Filter="Country=" & "'" & USA & "'"
Me.Filter="DepartmentID=" & 7

This should give you a solid starting point for your conversion.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Richard DanekeTrainerCommented:
It really depends on your version of Access.   ODBC drivers for dbase files will let you open the Lotus Approach databases.   You can then, copy the data into new Access tables using queries in Access.

As far as the rest - yes, you will need to recreate the forms and reports.  At least you can have tabbed operations now in Access similar to the Approach user interface.

Technically, you could keep the data as linked tables in Access, but I would NOT recommend it.
Jeffrey CoachmanMIS LiasonCommented:
glad I could help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.