Converting large number of Microsoft Works files to Access

[Carol]

My company's database currently consists of 450 Microsoft Works .wdb
files. All the files have a similar structure. When we moved to the
latest version of Works, we could no longer use mail-merge with
Microsoft Word. So we were thinking about moving to an Access
database.

It is a little cumbersome, though doable, to convert one Works file to
Access, via saving as .dbf. However, I'm faced with converting 450 of
these files! Is there any way to do a bulk conversion? Or should I
try something else altogether? Thanks for any ideas you might have.

Carol Spring

 

[John Nurick]

Hi Carol,

I've got an Access VBA module somewhere that used Word's mailmerge
facilities to extract data from a Works WDB file and create the
corresponding Access table. I used it a couple of years ago (Office XP,
Works 4.5 or 5). But I'm not up to speed on recent versions of Works
and/or any changes to the mailmerge object model in Word 2003.

If you'd like a copy, email me (remove the bogus middle name) and I'll
send you a zip file with the module in a little database file.