|
Home > Archive > MS Access data conversion > November 2005 > Converting large number of Microsoft Works files to Access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Converting large number of Microsoft Works files to Access
|
|
|
| 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 2005-11-01, 3:24 am |
| 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.
On 31 Oct 2005 18:55:32 -0800, "Carol" <spring@alum.mit.edu> wrote:
>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 [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|
|
|
|
|