answersLogoWhite

0


Best Answer

View products that this article applies to. Article ID : 197894 Last Review : November 16, 2004 Revision : 5.0 This article was previously published under Q197894For a Microsoft Access 97 version of this article, see 176201 (http://support.microsoft.com/kb/176201/). On This Page SUMMARYSaving the Works Database FileImporting the Works Database into Access

This article describes how to import a Works database file into a Microsoft Access 2000 database. This is a two-step process. First you must save the Works database file in a format compatible with Microsoft Access. Then you can import the Works database into Microsoft Access.

Back to the top Save the Works database file in a format compatible with Microsoft Access. To do so, follow these steps: 1. Open the database in Works. 2. Make sure the field widths in Form view are large enough to display all the information in the field. 3. Check the format of each field that contains text to ensure that it is General or Text formatting. If the format of a Text field is set to a numeric format, such as Currency or Date, the field will be blank when you open the database in Access. 4. When you save in dBASE format (as you will do in step 8), field names will be truncated at 10 characters, so ensure the first 10 characters of each field name are unique. For example, two fields named "Address 1" and "Address 2" would be OK, but "Address Line 1" and "Address Line 2" would not be.

NOTE: If the first 10 characters in two or more fields are the same, these field names will be imported into Access with a default field name, such as Field_1, Field_2, and so on. 5. On the File menu, click Save As. 6. Select a folder to which to save the database. To make the database easy to locate, select the Access folder. 7. Enter a new name, without an extension, in the File Name field.NOTE: When you import a dBASE file that does not follow the MS-DOS 8.3 file name convention (that is, an 8-character name followed by a period (.) and a 3-character extension), you may encounter problems when you try to import the dBASE file into Microsoft Access. Therefore, be sure to create a new file name that does not use more than 8 characters.

For more information, see: 209685 (http://support.microsoft.com/kb/209685/EN-US/) Could Not Find Object... Error When Importing dBASE, FoxPro, or Paradox File 8. In the Save File As Type list, select dBASE III or dBASE IV, and click Save.

NOTE: If you receive the error message, "Some Field Text Was Truncated," return to step 2 and increase the field width. 9. Quit Works. NOTE: If Works does not add the .dbf extension, resave the file with this extension.

Back to the top To import the database into Access, follow these steps: 1. Start Microsoft Access. 2. In the Microsoft Access dialog box, under "Create a new database using," click to select Blank Access Database, and then click OK. 3. Name the database, and then click Create. 4. In the Database window, under Objects, click Tables, and then click New. 5. In the New Table dialog box, select Import Table from the list, and then click OK. 6. In the Import dialog box, click the arrow in the Look In box, and select the folder that contains the dBASE file that you created in Microsoft Works. Click the arrow in the Files Of Type box, and select either dBASE III or dBASE IV, depending on the format you chose in step 8 of the "Saving the Works Database File" section earlier in this article. 7. Click the database that you want to use, and then click Import. You should receive a message that the file has been successfully imported. Click OK. Then close the Import dialog box.

The Works file has been imported into Access. If you want to view the imported data, select the new table in the Database Window, and click Open. If you want to discard the Works file used to transfer your data into Microsoft Access, delete the file.

For information about importing Works Spreadsheets into Microsoft Access, please see the following article in the Microsoft Knowledge Base: 209726 (http://support.microsoft.com/kb/209726/EN-US/) HOW TO: Import Spreadsheets from MS Works for Windows in Access 2000

Back to the top ---- APPLIES TO • Microsoft Access 2000 Standard Edition • Microsoft Works 2.0 Standard Edition • Microsoft Works 2.0a • Microsoft Works 3.0 Standard Edition • Microsoft Works 3.0a • Microsoft Works 3.0b • Microsoft Works 4.5 Standard Edition • Microsoft Works 4.5a • Microsoft Works 4.0 Standard Edition • Microsoft Works 4.0a Back to the top Keywords: kbimport kbhowtomaster kbinterop KB197894 View products that this article applies to. Article ID : 197894 Last Review : November 16, 2004 Revision : 5.0 This article was previously published under Q197894For a Microsoft Access 97 version of this article, see 176201 (http://support.microsoft.com/kb/176201/). On This Page SUMMARYSaving the Works Database FileImporting the Works Database into Access

This article describes how to import a Works database file into a Microsoft Access 2000 database. This is a two-step process. First you must save the Works database file in a format compatible with Microsoft Access. Then you can import the Works database into Microsoft Access.

Back to the top Save the Works database file in a format compatible with Microsoft Access. To do so, follow these steps: 1. Open the database in Works. 2. Make sure the field widths in Form view are large enough to display all the information in the field. 3. Check the format of each field that contains text to ensure that it is General or Text formatting. If the format of a Text field is set to a numeric format, such as Currency or Date, the field will be blank when you open the database in Access. 4. When you save in dBASE format (as you will do in step 8), field names will be truncated at 10 characters, so ensure the first 10 characters of each field name are unique. For example, two fields named "Address 1" and "Address 2" would be OK, but "Address Line 1" and "Address Line 2" would not be.

NOTE: If the first 10 characters in two or more fields are the same, these field names will be imported into Access with a default field name, such as Field_1, Field_2, and so on. 5. On the File menu, click Save As. 6. Select a folder to which to save the database. To make the database easy to locate, select the Access folder. 7. Enter a new name, without an extension, in the File Name field.NOTE: When you import a dBASE file that does not follow the MS-DOS 8.3 file name convention (that is, an 8-character name followed by a period (.) and a 3-character extension), you may encounter problems when you try to import the dBASE file into Microsoft Access. Therefore, be sure to create a new file name that does not use more than 8 characters.

For more information, see: 209685 (http://support.microsoft.com/kb/209685/EN-US/) Could Not Find Object... Error When Importing dBASE, FoxPro, or Paradox File 8. In the Save File As Type list, select dBASE III or dBASE IV, and click Save.

NOTE: If you receive the error message, "Some Field Text Was Truncated," return to step 2 and increase the field width. 9. Quit Works. NOTE: If Works does not add the .dbf extension, resave the file with this extension.

Back to the top To import the database into Access, follow these steps: 1. Start Microsoft Access. 2. In the Microsoft Access dialog box, under "Create a new database using," click to select Blank Access Database, and then click OK. 3. Name the database, and then click Create. 4. In the Database window, under Objects, click Tables, and then click New. 5. In the New Table dialog box, select Import Table from the list, and then click OK. 6. In the Import dialog box, click the arrow in the Look In box, and select the folder that contains the dBASE file that you created in Microsoft Works. Click the arrow in the Files Of Type box, and select either dBASE III or dBASE IV, depending on the format you chose in step 8 of the "Saving the Works Database File" section earlier in this article. 7. Click the database that you want to use, and then click Import. You should receive a message that the file has been successfully imported. Click OK. Then close the Import dialog box.

The Works file has been imported into Access. If you want to view the imported data, select the new table in the Database Window, and click Open. If you want to discard the Works file used to transfer your data into Microsoft Access, delete the file.

For information about importing Works Spreadsheets into Microsoft Access, please see the following article in the Microsoft Knowledge Base: 209726 (http://support.microsoft.com/kb/209726/EN-US/) HOW TO: Import Spreadsheets from MS Works for Windows in Access 2000

Back to the top ---- APPLIES TO • Microsoft Access 2000 Standard Edition • Microsoft Works 2.0 Standard Edition • Microsoft Works 2.0a • Microsoft Works 3.0 Standard Edition • Microsoft Works 3.0a • Microsoft Works 3.0b • Microsoft Works 4.5 Standard Edition • Microsoft Works 4.5a • Microsoft Works 4.0 Standard Edition • Microsoft Works 4.0a Back to the top Keywords: kbimport kbhowtomaster kbinterop KB197894

User Avatar

Wiki User

16y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

15y ago

Yes, you will be able to open a Microsoft works document but only if it is Microsoft Word 2007 and you right click the file and click "open with" and select the Microsoft word 2007 program. You can also save your Microsoft works document in "saved as" to be a Microsoft word document. All you do is have to go to "File" the go to "Save As" then go to "Save as type" and then click the down arrow next to the "Save as type" and click "word 97-2003 Document (*.doc)" or click "word 2007 Document (*.docx). This should work. I would save it as the word 97-2003 Document (*doc).

Hope this helps,

Waveracer200

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

A document created in Apple's Pages application (from the iWork suite) can either be Exported as a Word document or a copy can be Saved As... a Word document. Both of these options can be found from the Pages File menu. (See links below)

This answer is:
User Avatar

User Avatar

Wiki User

15y ago

It is possible due to Microsoft Works including word. It also depends on the file format of the word document, wether it is a 2007 file or 2003.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

Absolutely ! I have both programs on this computer (MS works was pre-loaded when I bought it !) and Open Office will happily read MS works database files.

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

You just need to save the works file as it is. Microsoft Word will be able to open it. If it doesn't open, save the works file as a Microsoft 97-03 file.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

If you save the Excel spreadsheet in a format that Microsoft Works can understand, then yes you can. Use the Save As facility to do so.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Is it possible to open a Microsoft Word document in Microsoft Works?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Can you save a MS Works document file into Microsoft Word?

You can open a MS Works document with MS Word.


Can you lock a Microsoft Works document?

Yes, you can certainly lock a Microsoft Word document. The technical name for this is document protection and it can be done right from the file menu on Word.


How can you make work done on a school computer that has Microsoft Word work on my home computer that has Microsoft Works?

If Works will not convert your Word document, you may have to re-save your document at school. If you click on "Save As", go down the list of possible formats. There should be one or two choices to save in a Works format.


How do you send a Microsoft Works document into Microsoft Word?

You can save your Microsoft works document in "saved as" to be a Microsoft word document. All you do is have to go to "File" the go to "Save As" then go to "Save as type" and then click the down arrow next to the "Save as type" and click "word 97-2003 Document (*.doc)" or click "word 2007 Document (*.docx). This should work. I would save it as the word 97-2003 Document (*doc). Hope this helps, Waveracer200


Is word document the same as Microsoft Word?

No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.No. A Word document is a file created by Microsoft Word.


What is the Microsoft Word?

A word document


Can you create separate files in MS Word Documents for entries in an Excel spreadsheet?

Microsoft Word and Microsoft Excel documents can be linked to each other, so that changes in one document will show up in the other. So it is possible to enter data in Microsoft Word and have it appear in Microsoft Excel. It is also possible to do formulas in tables in Microsoft Word, without linking to Microsoft Excel.


What does Microsoft Word 2010 mean?

Microsoft Word 2010 makes it easier to collaborate and to navigate through long documents. For more impact, new features focus on the polish of your finished document. With this new version, you can access the richness and familiarity of Word in your browser and on your mobile phone


How do you change a 97-2003 Microsoft word document to a 2007 Microsoft word document?

Open it with word 2007 and then save it from Save as command


What is the first step in creating Microsoft Word document?

open microsoft word


Is Microsoft Office and Microsoft Word the same?

No.Microsoft Works word processor is a less robust, less feature-rich word processing product when compared with Microsoft Word.You can use Microsoft Word, however, to open a Microsoft Works document. When you use Microsoft Works to open a Microsoft Word document, you limit your ability to develop results using the robust features of Word .You can read more using the links below.No. They are made by the same company and are similar, but Microsoft Word would have more facilities. Another difference is that you have to pay for it, whereas Works comes free.


Is Microsoft Word document saved with an extension document?

Yes