Converting Lotus Approach .apr to Excel or other Database files, Music Spreadsheet Win7


This is a very boring subject…

Yes I know this is a very boring topic, but one worth posting as after 10 years of using Lotus approach to spreadsheet and database my record collection I needed to upgrade and update to something that would actually run on Win7.

Export your .apr file/database/spreadsheets as excel files using the export (as) function in Lotus and then… bascially using either the full or lite packaged version of Microsoft office which hopefully in your case came with your P.C. and bundle of Microsoft office ‘tools’ import the excel file and edit and carry on with your databasing. you will find a few annoyances such as filtered search results as of yet don’t seem to operate in the same way, but hell just having the possibility of saving years of work seems worth doing eh?

I’d searched for all kinds of complicated and costly ways to update and continue on with my database and in the end stumbled on this. Perhaps this may help you?

Hope so…

Advertisements

6 thoughts on “Converting Lotus Approach .apr to Excel or other Database files, Music Spreadsheet Win7”

  1. how do you get back to database view from mail label view stuck on that and do not know how to get back to database view help

    1. Your best bet is to salvage the data. Lotus Approach is marginal with Windows 7 and very prone to issues like you are experiencing. Get MS Excel (any recent version) goto “Open” and navigate to the folder that contains your Approach files. In the Excel screen change the file type to dBase and open the Approach file that has a file type “.dbf”
      You will see your data as a spreadsheet. Immediately “save” what you’ve opened but change the file type to a “.xl” (or similar) so you can open it again in Excel.
      Good luck.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s