[AccessD] Would Like to Display Microsoft Works Data via Access2007

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



More information about the AccessD mailing list