Converting Works 2.0/3.0 WDB files to Access 2000

[Guest]

I have gotten stuck with works 2.0/3.0 WDB files I need to import into Access
2000

 

[Amy Vargo]

Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
You can't import a Microsoft Works database (.wdb) directly into Microsoft
Access. You must first use Microsoft Works to save the file to one of the
file formats that Microsoft Access can import. To do so:

1. Open the database by using Microsoft Works.
2. On the File menu, click Save As.
3. In the Save As Type box, select dBASE IV, and then click OK.
4. Import the dBASE IV .dbf file that you created in step 3 into Microsoft
Access.
5. To import files, on the File menu, point to Get External Data, and then
click Import.
6. In the Import (or Link) dialog box, in the Files Of Type box, select one
of the dBASE file types.
7.Click the arrow to the right of the Look In box, select the drive and
folder where the .dbf file is located, and then double-click its icon.
8.Continue through the wizard to import the data.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

 

[CrypticOne]

Ah, very good, but does anyone know how to open a wdb file without M
Works. I am having this problem as we do not have MS Works

*Hi,

My name is Amy Vargo. Thank you for using the Microsoft Acces
Newsgroups.
You can't import a Microsoft Works database (.wdb) directly int
Microsoft
Access. You must first use Microsoft Works to save the file to one o
the
file formats that Microsoft Access can import. To do so:

1. Open the database by using Microsoft Works.
2. On the File menu, click Save As.
3. In the Save As Type box, select dBASE IV, and then click OK.
4. Import the dBASE IV .dbf file that you created in step 3 int
Microsoft
Access.
5. To import files, on the File menu, point to Get External Data, an
then
click Import.
6. In the Import (or Link) dialog box, in the Files Of Type box
select one
of the dBASE file types.
7.Click the arrow to the right of the Look In box, select the driv
and
folder where the .dbf file is located, and then double-click it
icon.
8.Continue through the wizard to import the data.

I hope this helps! If you have additional questions on this topic
please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers n
rights.
You assume all risk for your use. © 2001 Microsoft Corporation. Al
rights
reserved.

-
CrypticOn

 

[John Vinson]

Ah, very good, but does anyone know how to open a wdb file without MS
Works. I am having this problem as we do not have MS Works

I believe you can import Works files into Excel - though you cannot
import them into Access. Try using Excel to relay the data (since
Access *can* read Excel).

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