Convert Works Database to Access

[Fran]

Can someone much smarter than me tell me how to convert an MS Works database
to an MS Access Database? Thanks in advance, Fran

 

[Guest]

Hi Fran,

I don't think you can directly convert from Works to Access... however you
can import the tables from Works by first saving your Works database in a
format that Access can import (eg: DBase *.dbf) then importing from that into
Access.

Hope this helps.

Damian.

 

[John Vinson]

Can someone much smarter than me tell me how to convert an MS Works database
to an MS Access Database? Thanks in advance, Fran

It is probably impossibe to do so directly.

Works and Access have utterly different logical structures; the user
interface (reports and forms) must be done in completely different
ways using different ground assumptions.

You can't even *directly* import the data from WOrks into Access -
you'll need to save it from Works in a common format such as dBase
(.dbf file), Excel, or comma-separated-values text file. These can be
imported into an Access table. You'll almost surely need to revise the
table structure, since Access is much more relational than Works.

Good luck; we'll be glad to help you over the rough spots!

John W. Vinson[MVP]