Software

Ask something
Discussion Locked

Convert Works DB to Excel/Access

0 helpful
7 replies

by gmiller

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I convert a database created in MS Works (.wdb) to a format that can be opened by MS Excel or Access?

7 replies

by donq

I would be very surprised if Access didn't allow the user to "import" .wdb components (Tables, queries, etc) on an individual basis.

OR

Export Works objects as text files and inport text files into Access.

by dklippert

For the Microsoft answers, type one of the following into the address box of Internet Explorer:
For '97
Access

MSKB Q176201

Excel

MSKB Q93698

If you have Office 2000, use these entries:

Access

MSKB Q197894

Excel

MSKB Q209720

by dcrowe

I'm not overly familiar with Works or Excel, but I would look for a 'Save As' option of either comma or tab delimited file. This would readily import into Access - I've done that for years. I'm pretty sure that Excel recognizes delim files as well.

by gmiller

Thanks, I was able to Save As 'text & commas' in Works and then sucessfully import into both Excel and Access using Data/Get External Data/Import Text File

This discussion is closed to new replies.