[AccessD] Would Like to Display Microsoft Works Data via Access 2007

All you should need to do is fire up Works on the old PC, load the Works spreadsheet and then choose Save As on the File menu, selecting the file type "Excel 97-2000". See http://spreadsheets.about.com/od/otherspreadsheets/ss/convert_works.htm

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, August 29, 2013 4:12 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Would Like to Display Microsoft Works Data via Access 2007

All, 

We have one old PC in the factory that has Microsoft Works 2000 Version 5.0.

This PC is not used very much, but it does provide a way to work with a single Works file (which is stored on a server).

I would like to replace this old PC with a new one and replace Works with Excel.  This is not going to happen in the near future, however.

I am curious if there is a way (a utility) to automatically pull the data from the Works file and populate an Excel file with this data.
Then I could get at the Excel file from Access.  We have an existing "Inquiry" system that is built with Access-2007 that works very nicely.
It would be great if we could somehow integrate this old Works data into our existing Inquiry system.

I am open to all ideas.

Thanks,
Brad
  

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com