WLCummings
Registered User.
- Local time
- Today, 02:55
- Joined
- Sep 3, 2012
- Messages
- 26
Is there an easy way to import a Lotus Approach DB back end and front end to Access 2010?
Lotus Approach to Access
- Thread starter WLCummings
- Start date
- Local time
- Today, 05:55
- Joined
- Feb 19, 2002
- Messages
- 46,972
I don't have A2003 available but I think it had an ODBC driver that let you import Approach tables. If you don't have it, go back to the original installation CD and make sure you choose to install all the drivers. Default installations probably do not include it since it is not very common. I always do full installs and I don't see the driver for Approach in A2010.
WLCummings
Registered User.
- Local time
- Today, 02:55
- Joined
- Sep 3, 2012
- Messages
- 26
Pat, I have Access 2010 and it has the ODBC import icon so if Approach is compatible then it should work - I'm going to suggest to my client he update to Access and I would like to know how much of the front end it will convert.
- Local time
- Today, 05:55
- Joined
- Feb 19, 2002
- Messages
- 46,972
As I said, I looked at the ODBC options loaded with A2010 and Approach isn't among them. You probably need an earlier version of Access or you need to get the driver from Lotus directly.
Assuming you find an ODBC driver for Approach, it will only convert data. It will NOT convert any of the other parts of the application. That's not what ODBC drivers do. They simply allow you to access data in different formats. I have never seen a tool that converted an Approach application to Access but that doesn't mean they don't exist. Try searching for that specifically. You might get lucky. But, I would be prepared to rewrite the app were I you and just be happy that I could convert the data easily.
If you don't find an ODBC driver, you will need to have Approach so you can export the data to csv or xls files.
Assuming you find an ODBC driver for Approach, it will only convert data. It will NOT convert any of the other parts of the application. That's not what ODBC drivers do. They simply allow you to access data in different formats. I have never seen a tool that converted an Approach application to Access but that doesn't mean they don't exist. Try searching for that specifically. You might get lucky. But, I would be prepared to rewrite the app were I you and just be happy that I could convert the data easily.
If you don't find an ODBC driver, you will need to have Approach so you can export the data to csv or xls files.
Lightwave
Ad astra
- Local time
- Today, 10:55
- Joined
- Sep 27, 2004
- Messages
- 1,537
WL - regards your front end - I don't have a lot of experience with Lotus Approach but access converts 0% of any front end except from previous Access versions. This is not a weakness of Access all development environments are sufficiently unique that front ends are universally non automatically transferrable.
WLCummings
Registered User.
- Local time
- Today, 02:55
- Joined
- Sep 3, 2012
- Messages
- 26
Pat and Lightwave, thanks for your replies, I will plan on client exporting to compatible format and then rewrite front end.
Pat I misread your first note sorry but now when i reread it makes sense.
Bill
Pat I misread your first note sorry but now when i reread it makes sense.
Bill
