Converting data in an MS Works database to MS Access

[Guest]

Is there a way to convert data in an MS Works databade over to a MS Access
data base? If so, how would it be done?

 

[John Vinson]

Is there a way to convert data in an MS Works databade over to a MS Access
data base? If so, how would it be done?

Not directly, oddly enough; Microsoft didn't supply that link between
two of their database offerings. I'd suggest exporting the data from
Works to a format that Access can read: dBase or comma-separated text.
If you have a .wkd file but don't have Works installed, you should be
able to open it in Excel, save it as an Excel workbook, and import
*that* into Access.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Douglas J. Steele]

Access doesn't recognize the Works format.

Open the database in Works and export it to a format that Access will
recognize (such as csv or dbf). You should then be able to import that into
Access.

It may also be possible to open it in Excel. Once you've save the
spreadsheet, Access can handle it.