Convert Works Database to Access

F

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
 
G

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.
 
J

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
Click to expand...

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import MS Works database to Access 2007 8
how to convert the bytes to word document in ms access database 1
Convert MS Access .MDB to Works Database .WDB 5
Open/Convert Works Database .wdb file in Access 4
Convert Access database to 97 1
HOWTO convert programmatically .MDB to .ACCDB 1
Microsoft Works to Microsoft Office 6
How do I store which user modified a record in Access 2007? 5

Top