|
 |
access thread: Works to Access
Message #1 by Joe Constant <jconstant@h...> on Thu, 13 Dec 2001 12:58:04 -0800
|
|
Anyone know of a utility to convert Works databases to Access? My company
has a database in Works that is fairly complex and I have been commissioned
to convert it to Access. Any help would be greatly appreciated.
Joe
Message #2 by "John Ruff" <papparuff@c...> on Thu, 13 Dec 2001 14:04:48 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_002D_01C183DF.20A56360
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 12:58 PM
To: Access
Subject: [access] Works to Access
Anyone know of a utility to convert Works databases to Access? My
company has a database in Works that is fairly complex and I have been
commissioned to convert it to Access. Any help would be greatly
appreciated.
Joe
Message #3 by Walt Morgan <wmorgan@s...> on Thu, 13 Dec 2001 15:46:10 -0600
|
|
Joe,
This may help,
Walt
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q163108
Message #4 by Joe Constant <jconstant@h...> on Thu, 13 Dec 2001 14:20:31 -0800
|
|
That would give me the data, but is there any way of importing the forms and
reports?
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Thursday, December 13, 2001 2:05 PM
To: Access
Subject: [access] RE: Works to Access
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist J
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 12:58 PM
To: Access
Subject: [access] Works to Access
Anyone know of a utility to convert Works databases to Access? My company
has a database in Works that is fairly complex and I have been commissioned
to convert it to Access. Any help would be greatly appreciated.
Joe
Message #5 by "John Ruff" <papparuff@c...> on Thu, 13 Dec 2001 14:41:14 -0800
|
|
Joe,
These two articles tell you what you need to do to the Works DB to
import the data into Access properly. They also tell you how to import
the databases once you have made the necessary changes.
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 2:21 PM
To: Access
Subject: [access] RE: Works to Access
That would give me the data, but is there any way of importing the forms
and reports?
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Thursday, December 13, 2001 2:05 PM
To: Access
Subject: [access] RE: Works to Access
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist J
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 12:58 PM
To: Access
Subject: [access] Works to Access
Anyone know of a utility to convert Works databases to Access? My
company has a database in Works that is fairly complex and I have been
commissioned to convert it to Access. Any help would be greatly
appreciated.
Joe
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to $subst('Email.Unsub').
Message #6 by Joe Constant <jconstant@h...> on Fri, 14 Dec 2001 06:10:08 -0800
|
|
OK, I followed the instructions but still, all it imports is the data. I
need the forms and reports. The links you provided only specify how to
import the data or how to import spreadsheets.
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Thursday, December 13, 2001 2:41 PM
To: Access
Subject: [access] RE: Works to Access
Joe,
These two articles tell you what you need to do to the Works DB to
import the data into Access properly. They also tell you how to import
the databases once you have made the necessary changes.
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 2:21 PM
To: Access
Subject: [access] RE: Works to Access
That would give me the data, but is there any way of importing the forms
and reports?
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Thursday, December 13, 2001 2:05 PM
To: Access
Subject: [access] RE: Works to Access
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist J
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 12:58 PM
To: Access
Subject: [access] Works to Access
Anyone know of a utility to convert Works databases to Access? My
company has a database in Works that is fairly complex and I have been
commissioned to convert it to Access. Any help would be greatly
appreciated.
Joe
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to $subst('Email.Unsub').
Message #7 by "John Ruff" <papparuff@c...> on Fri, 14 Dec 2001 09:29:29 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_002E_01C18481.D4C76710
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit
I know of no way to import Works forms and reports but maybe this might
work (I don't have Works so I can't try it):
Open your Access db.
Select File > Get External Data > Import
Go to the "Files of type" field and select "ODBC Databases"
Check to see if Works is listed as a "File Data Source"
If it is, then you might be able to import the forms and report. If
not, it looks as if you are going to have to design them from scratch.
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Friday, December 14, 2001 6:10 AM
To: Access
Subject: [access] RE: Works to Access
OK, I followed the instructions but still, all it imports is the data.
I need the forms and reports. The links you provided only specify how
to import the data or how to import spreadsheets.
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Thursday, December 13, 2001 2:41 PM
To: Access
Subject: [access] RE: Works to Access
Joe,
These two articles tell you what you need to do to the Works DB to
import the data into Access properly. They also tell you how to import
the databases once you have made the necessary changes.
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 2:21 PM
To: Access
Subject: [access] RE: Works to Access
That would give me the data, but is there any way of importing the forms
and reports?
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Thursday, December 13, 2001 2:05 PM
To: Access
Subject: [access] RE: Works to Access
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist J
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 12:58 PM
To: Access
Subject: [access] Works to Access
Anyone know of a utility to convert Works databases to Access? My
company has a database in Works that is fairly complex and I have been
commissioned to convert it to Access. Any help would be greatly
appreciated.
Joe
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to $subst('Email.Unsub').
Message #8 by Joe Constant <jconstant@h...> on Fri, 14 Dec 2001 09:40:10 -0800
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C184C6.60A39990
Content-Type: text/plain;
charset="iso-8859-1"
It's not listed. I guess I'm stuck writing them from scratch. I guess it
just goes to show, laziness doesn't pay.
Thanks for all your help anyway.
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Friday, December 14, 2001 9:29 AM
To: Access
Subject: [access] RE: Works to Access
I know of no way to import Works forms and reports but maybe this might work
(I don't have Works so I can't try it):
Open your Access db.
Select File > Get External Data > Import
Go to the "Files of type" field and select "ODBC Databases"
Check to see if Works is listed as a "File Data Source"
If it is, then you might be able to import the forms and report. If not, it
looks as if you are going to have to design them from scratch.
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [ mailto:jconstant@h...
<mailto:jconstant@h...> ]
Sent: Friday, December 14, 2001 6:10 AM
To: Access
Subject: [access] RE: Works to Access
OK, I followed the instructions but still, all it imports is the data. I
need the forms and reports. The links you provided only specify how to
import the data or how to import spreadsheets.
Joe
-----Original Message-----
From: John Ruff [ mailto:papparuff@c... <mailto:papparuff@c...> ]
Sent: Thursday, December 13, 2001 2:41 PM
To: Access
Subject: [access] RE: Works to Access
Joe,
These two articles tell you what you need to do to the Works DB to import
the data into Access properly. They also tell you how to import the
databases once you have made the necessary changes.
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201>
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894>
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [ mailto:jconstant@h...
<mailto:jconstant@h...> ]
Sent: Thursday, December 13, 2001 2:21 PM
To: Access
Subject: [access] RE: Works to Access
That would give me the data, but is there any way of importing the forms and
reports?
Joe
-----Original Message-----
From: John Ruff [ mailto:papparuff@c... <mailto:papparuff@c...> ]
Sent: Thursday, December 13, 2001 2:05 PM
To: Access
Subject: [access] RE: Works to Access
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201>
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894>
John Ruff - The Eternal Optimist J
-----Original Message-----
From: Joe Constant [ mailto:jconstant@h...
<mailto:jconstant@h...> ]
Sent: Thursday, December 13, 2001 12:58 PM
To: Access
Subject: [access] Works to Access
Anyone know of a utility to convert Works databases to Access? My company
has a database in Works that is fairly complex and I have been commissioned
to convert it to Access. Any help would be greatly appreciated.
Joe
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub').
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
Message #9 by "John Ruff" <papparuff@c...> on Fri, 14 Dec 2001 09:41:35 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01C18483.862F8D10
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
One more off the wall thing to try. Open both databases and see if you
can drag and drop a form from the Works db to the Access db. It works
from Access to Access so why not?
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Friday, December 14, 2001 9:40 AM
To: Access
Subject: [access] RE: Works to Access
It's not listed. I guess I'm stuck writing them from scratch. I guess
it just goes to show, laziness doesn't pay.
Thanks for all your help anyway.
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Friday, December 14, 2001 9:29 AM
To: Access
Subject: [access] RE: Works to Access
I know of no way to import Works forms and reports but maybe this might
work (I don't have Works so I can't try it):
Open your Access db.
Select File > Get External Data > Import
Go to the "Files of type" field and select "ODBC Databases"
Check to see if Works is listed as a "File Data Source"
If it is, then you might be able to import the forms and report. If
not, it looks as if you are going to have to design them from scratch.
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Friday, December 14, 2001 6:10 AM
To: Access
Subject: [access] RE: Works to Access
OK, I followed the instructions but still, all it imports is the data.
I need the forms and reports. The links you provided only specify how
to import the data or how to import spreadsheets.
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Thursday, December 13, 2001 2:41 PM
To: Access
Subject: [access] RE: Works to Access
Joe,
These two articles tell you what you need to do to the Works DB to
import the data into Access properly. They also tell you how to import
the databases once you have made the necessary changes.
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 2:21 PM
To: Access
Subject: [access] RE: Works to Access
That would give me the data, but is there any way of importing the forms
and reports?
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Thursday, December 13, 2001 2:05 PM
To: Access
Subject: [access] RE: Works to Access
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
John Ruff - The Eternal Optimist J
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Thursday, December 13, 2001 12:58 PM
To: Access
Subject: [access] Works to Access
Anyone know of a utility to convert Works databases to Access? My
company has a database in Works that is fairly complex and I have been
commissioned to convert it to Access. Any help would be greatly
appreciated.
Joe
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to $subst('Email.Unsub').
Message #10 by Joe Constant <jconstant@h...> on Fri, 14 Dec 2001 09:54:34 -0800
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C184C8.63ADE170
Content-Type: text/plain;
charset="iso-8859-1"
No go. Nice idea though.
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Friday, December 14, 2001 9:42 AM
To: Access
Subject: [access] RE: Works to Access
One more off the wall thing to try. Open both databases and see if you can
drag and drop a form from the Works db to the Access db. It works from
Access to Access so why not?
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [mailto:jconstant@h...]
Sent: Friday, December 14, 2001 9:40 AM
To: Access
Subject: [access] RE: Works to Access
It's not listed. I guess I'm stuck writing them from scratch. I guess it
just goes to show, laziness doesn't pay.
Thanks for all your help anyway.
Joe
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Friday, December 14, 2001 9:29 AM
To: Access
Subject: [access] RE: Works to Access
I know of no way to import Works forms and reports but maybe this might work
(I don't have Works so I can't try it):
Open your Access db.
Select File > Get External Data > Import
Go to the "Files of type" field and select "ODBC Databases"
Check to see if Works is listed as a "File Data Source"
If it is, then you might be able to import the forms and report. If not, it
looks as if you are going to have to design them from scratch.
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [ mailto:jconstant@h...
<mailto:jconstant@h...> ]
Sent: Friday, December 14, 2001 6:10 AM
To: Access
Subject: [access] RE: Works to Access
OK, I followed the instructions but still, all it imports is the data. I
need the forms and reports. The links you provided only specify how to
import the data or how to import spreadsheets.
Joe
-----Original Message-----
From: John Ruff [ mailto:papparuff@c... <mailto:papparuff@c...> ]
Sent: Thursday, December 13, 2001 2:41 PM
To: Access
Subject: [access] RE: Works to Access
Joe,
These two articles tell you what you need to do to the Works DB to import
the data into Access properly. They also tell you how to import the
databases once you have made the necessary changes.
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201>
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894>
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Joe Constant [ mailto:jconstant@h...
<mailto:jconstant@h...> ]
Sent: Thursday, December 13, 2001 2:21 PM
To: Access
Subject: [access] RE: Works to Access
That would give me the data, but is there any way of importing the forms and
reports?
Joe
-----Original Message-----
From: John Ruff [ mailto:papparuff@c... <mailto:papparuff@c...> ]
Sent: Thursday, December 13, 2001 2:05 PM
To: Access
Subject: [access] RE: Works to Access
Go to Microsoft's Knowledgebase and lookup Article ID Q176201,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201>
Or Article ID Q197894,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894>
John Ruff - The Eternal Optimist J
-----Original Message-----
From: Joe Constant [ mailto:jconstant@h...
<mailto:jconstant@h...> ]
Sent: Thursday, December 13, 2001 12:58 PM
To: Access
Subject: [access] Works to Access
Anyone know of a utility to convert Works databases to Access? My company
has a database in Works that is fairly complex and I have been commissioned
to convert it to Access. Any help would be greatly appreciated.
Joe
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub').
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
to unsubscribe send a blank email to $subst('Email.Unsub'). ---
Message #11 by Dave Sharpe <pmmgpgp@y...> on Fri, 14 Dec 2001 11:32:01 -0800 (PST)
|
|
Joe
I found this at
http://www.smartcomputing.com/editorial/article.asp?article=articles%2F1996%2Fsep96%2F96n0916%2F96n0916%2Easp
(Pardon the word wrapping )
Dave
============
Transferring Files.
One of the most important aspects of upgrading from
Works to Office is that you can open your files from
Works in Office applications. Transferring your
documents to the Office application lets you remove
Works from your system, which you may well need to do
now that you have Office taking up a large chunk of
storage. Even if you?re not removing Works for
whatever reason, you may find that you prefer to have
some of your old documents in formats supported by the
Office applications.
In most cases, working with Works files in Office
applications requires that you save your Works files
in a format other than the standard Works formats for
word processing documents (Works WP), spreadsheets
(Works SS), or databases (Works DB). To change the
format in which you save a Works document, choose Save
As from the File menu while you have the document
open. Choose the appropriate file format from the Save
As Type drop-down list (if you?re using Win95) or the
Save File As Type list (if you?re using an earlier
version of Windows). We?ll talk about what formats you
can use in Works and Office applications as we cover
each type of document you might want to transfer.
Databases. You cannot use Microsoft Access to open
Works databases. However, you can get around this
problem by importing a database from Works into
Access. To do so, you must save the database in dBASE
III or dBASE IV format in Works. (Both of these
formats are available in both the Windows 3.1 and
Win95 versions of Works.) Then, when you open Access,
just create a new database into which you can import
the Works database.
To do this, choose New Database from the File menu,
choose Blank Database from the New window, and click
OK. Name the new database in the File New Database
window by typing the name in the File Name line and
click Create. This creates a blank database, with tabs
for tables, queries, forms, reports, macros, and
modules. The Tables will be the open tab; click New.
In the New Table window that appears, choose Import
Table and click OK. In the Import window, select the
file you want to import. It will probably be in the
C:\PROGRAM FILES\MSWORKS\DOCUMENTS folder. Make sure
the Files Of Type line displays the type of file that
you saved your database as in Works; otherwise, the
file you want won?t be listed. When you find the file,
click it, then click Import. Access will display a
message saying that you have successfully imported the
file; click OK, then close the Import window. The
imported file will be represented by an icon in the
Tables window of the new database you created in
Access. To open the Works database, select it and
click Open.
--- John Ruff <papparuff@c...> wrote:
> I know of no way to import Works forms and reports
> but maybe this might
> work (I don't have Works so I can't try it):
>
> Open your Access db.
> Select File > Get External Data > Import
> Go to the "Files of type" field and select "ODBC
> Databases"
> Check to see if Works is listed as a "File Data
> Source"
>
> If it is, then you might be able to import the forms
> and report. If
> not, it looks as if you are going to have to design
> them from scratch.
>
>
>
> John Ruff - The Eternal Optimist :-)
>
>
>
>
> -----Original Message-----
> From: Joe Constant
> [mailto:jconstant@h...]
> Sent: Friday, December 14, 2001 6:10 AM
> To: Access
> Subject: [access] RE: Works to Access
>
>
> OK, I followed the instructions but still, all it
> imports is the data.
> I need the forms and reports. The links you
> provided only specify how
> to import the data or how to import spreadsheets.
>
>
>
> Joe
>
>
> -----Original Message-----
> From: John Ruff [mailto:papparuff@c...]
> Sent: Thursday, December 13, 2001 2:41 PM
> To: Access
> Subject: [access] RE: Works to Access
>
>
> Joe,
>
> These two articles tell you what you need to do to
> the Works DB to
> import the data into Access properly. They also
> tell you how to import
> the databases once you have made the necessary
> changes.
>
> Go to Microsoft's Knowledgebase and lookup Article
> ID Q176201,
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
>
> Or Article ID Q197894,
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
>
> John Ruff - The Eternal Optimist :-)
>
>
>
> -----Original Message-----
> From: Joe Constant
> [mailto:jconstant@h...]
> Sent: Thursday, December 13, 2001 2:21 PM
> To: Access
> Subject: [access] RE: Works to Access
>
>
> That would give me the data, but is there any way of
> importing the forms
> and reports?
>
>
>
> Joe
>
> -----Original Message-----
> From: John Ruff [mailto:papparuff@c...]
> Sent: Thursday, December 13, 2001 2:05 PM
> To: Access
> Subject: [access] RE: Works to Access
>
>
> Go to Microsoft's Knowledgebase and lookup Article
> ID Q176201,
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
>
> Or Article ID Q197894,
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
>
>
>
> John Ruff - The Eternal Optimist J
>
>
>
>
> -----Original Message-----
> From: Joe Constant
> [mailto:jconstant@h...]
> Sent: Thursday, December 13, 2001 12:58 PM
> To: Access
> Subject: [access] Works to Access
>
>
> Anyone know of a utility to convert Works databases
> to Access? My
> company has a database in Works that is fairly
> complex and I have been
> commissioned to convert it to Access. Any help
> would be greatly
> appreciated.
>
>
>
> Joe
>
__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
Message #12 by Joe Constant <jconstant@h...> on Fri, 14 Dec 2001 12:19:08 -0800
|
|
Looks like it's pretty much the same info that John had given me. Thanks
anyway.
Joe
-----Original Message-----
From: Dave Sharpe [mailto:pmmgpgp@y...]
Sent: Friday, December 14, 2001 11:32 AM
To: Access
Subject: [access] RE: Works to Access
Joe
I found this at
http://www.smartcomputing.com/editorial/article.asp?article=articles%2F1996%
2Fsep96%2F96n0916%2F96n0916%2Easp
(Pardon the word wrapping )
Dave
============
Transferring Files.
One of the most important aspects of upgrading from
Works to Office is that you can open your files from
Works in Office applications. Transferring your
documents to the Office application lets you remove
Works from your system, which you may well need to do
now that you have Office taking up a large chunk of
storage. Even if you're not removing Works for
whatever reason, you may find that you prefer to have
some of your old documents in formats supported by the
Office applications.
In most cases, working with Works files in Office
applications requires that you save your Works files
in a format other than the standard Works formats for
word processing documents (Works WP), spreadsheets
(Works SS), or databases (Works DB). To change the
format in which you save a Works document, choose Save
As from the File menu while you have the document
open. Choose the appropriate file format from the Save
As Type drop-down list (if you're using Win95) or the
Save File As Type list (if you're using an earlier
version of Windows). We'll talk about what formats you
can use in Works and Office applications as we cover
each type of document you might want to transfer.
Databases. You cannot use Microsoft Access to open
Works databases. However, you can get around this
problem by importing a database from Works into
Access. To do so, you must save the database in dBASE
III or dBASE IV format in Works. (Both of these
formats are available in both the Windows 3.1 and
Win95 versions of Works.) Then, when you open Access,
just create a new database into which you can import
the Works database.
To do this, choose New Database from the File menu,
choose Blank Database from the New window, and click
OK. Name the new database in the File New Database
window by typing the name in the File Name line and
click Create. This creates a blank database, with tabs
for tables, queries, forms, reports, macros, and
modules. The Tables will be the open tab; click New.
In the New Table window that appears, choose Import
Table and click OK. In the Import window, select the
file you want to import. It will probably be in the
C:\PROGRAM FILES\MSWORKS\DOCUMENTS folder. Make sure
the Files Of Type line displays the type of file that
you saved your database as in Works; otherwise, the
file you want won't be listed. When you find the file,
click it, then click Import. Access will display a
message saying that you have successfully imported the
file; click OK, then close the Import window. The
imported file will be represented by an icon in the
Tables window of the new database you created in
Access. To open the Works database, select it and
click Open.
--- John Ruff <papparuff@c...> wrote:
> I know of no way to import Works forms and reports
> but maybe this might
> work (I don't have Works so I can't try it):
>
> Open your Access db.
> Select File > Get External Data > Import
> Go to the "Files of type" field and select "ODBC
> Databases"
> Check to see if Works is listed as a "File Data
> Source"
>
> If it is, then you might be able to import the forms
> and report. If
> not, it looks as if you are going to have to design
> them from scratch.
>
>
>
> John Ruff - The Eternal Optimist :-)
>
>
>
>
> -----Original Message-----
> From: Joe Constant
> [mailto:jconstant@h...]
> Sent: Friday, December 14, 2001 6:10 AM
> To: Access
> Subject: [access] RE: Works to Access
>
>
> OK, I followed the instructions but still, all it
> imports is the data.
> I need the forms and reports. The links you
> provided only specify how
> to import the data or how to import spreadsheets.
>
>
>
> Joe
>
>
> -----Original Message-----
> From: John Ruff [mailto:papparuff@c...]
> Sent: Thursday, December 13, 2001 2:41 PM
> To: Access
> Subject: [access] RE: Works to Access
>
>
> Joe,
>
> These two articles tell you what you need to do to
> the Works DB to
> import the data into Access properly. They also
> tell you how to import
> the databases once you have made the necessary
> changes.
>
> Go to Microsoft's Knowledgebase and lookup Article
> ID Q176201,
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
>
> Or Article ID Q197894,
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
>
> John Ruff - The Eternal Optimist :-)
>
>
>
> -----Original Message-----
> From: Joe Constant
> [mailto:jconstant@h...]
> Sent: Thursday, December 13, 2001 2:21 PM
> To: Access
> Subject: [access] RE: Works to Access
>
>
> That would give me the data, but is there any way of
> importing the forms
> and reports?
>
>
>
> Joe
>
> -----Original Message-----
> From: John Ruff [mailto:papparuff@c...]
> Sent: Thursday, December 13, 2001 2:05 PM
> To: Access
> Subject: [access] RE: Works to Access
>
>
> Go to Microsoft's Knowledgebase and lookup Article
> ID Q176201,
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176201
>
> Or Article ID Q197894,
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197894
>
>
>
> John Ruff - The Eternal Optimist J
>
>
>
>
> -----Original Message-----
> From: Joe Constant
> [mailto:jconstant@h...]
> Sent: Thursday, December 13, 2001 12:58 PM
> To: Access
> Subject: [access] Works to Access
>
>
> Anyone know of a utility to convert Works databases
> to Access? My
> company has a database in Works that is fairly
> complex and I have been
> commissioned to convert it to Access. Any help
> would be greatly
> appreciated.
>
>
>
> Joe
>
__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
|
|
|
View Cart
