Jim Dettman
jimdettman at verizon.net
Fri Aug 30 14:34:44 CDT 2013
I actually just stumbled over this the other night (wife got a file for Choir that was in works format). Turns out, there's not much out there :( Every solution I saw was "open up works on a PC that has it, and save in DBF format". Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, August 30, 2013 03:20 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Would Like to Display Microsoft Works Data via Access2007 Lambert, Thanks for the help. I was hoping to find a utility that would convert the Works Spreadsheet file (that lives on a server) to something that Access 2007 could read, such as an Excel file. I wanted to do this by simply reading the Works file on the server and not touching the old PC that has Works installed. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, August 30, 2013 8:25 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Would Like to Display Microsoft Works Data via Access2007 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=79F3D28899.929EE -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com