I believe that you are familiar with the Word and Access members of the Microsoft Office family. There is a close relationship between them. For example, in terms of data exchange, the following uses Word2000 and Access2000 as examples, the following describes how to exchange Word and Access data: 1. Use Access Data in Word (1 ).
I believe that you are familiar with the Word and Access members of the Microsoft Office family. There is a close relationship between them. For example, in terms of data exchange, the following uses Word2000 and Access2000 as examples, the following describes how to exchange Word and Access data: 1. Use Access Data in Word (1 ).
I believe that you are familiar with the Word and Access members of the Microsoft Office family. There is a close relationship between them. For example, in terms of data exchange, the following uses Word2000 and Access2000 as examples, the following describes how to exchange Word and Access data:
1. Data Using Access in Word
(1) how to insert a Microsoft Access Table or query content into the original Word document.
1. In a Word document, select the location where the table is to be inserted or queried.
2. Go to the "toolbar" in the "View" menu, click "Database", display "Database" toolbar, and click "insert Database", as shown in 1.
3. In the pop-up "Database" window, click? Quot; get data "button, select" MSAccess Database "in" file type "of" open data source ". In the "file name" box, enter the name of the required Microsoft Access database, and click "open.
4. Click "table" or "query", select the expected table or query, as shown in figure 2, and click "OK.
5. if you want to select records, fields, or subsets, and include them in the Word Table, click "query options" to select the required options, as shown in 3, click OK.
6. If you want to customize the form of a Word table, click the "" button, select the required options, and click the "OK" button.
7. Click "insert data". Under "insert record", select the records you want to include in the Word Table.
8. If you want to update the data in the Word table when the source data changes, select the "insert data as a field" check box and click "OK.
(2) Output Microsoft Access data to the Word documents
1. In Access2000, open the required database, and then open the database object: Table, query, form, or report.
2. Select the rows and columns of the data to be output.
3. Click "Save As/export" in the "file" menu.
4. Select "Save as an external file or database" and click "OK.
5. in the "Save type" box, select a format for the output data. To create a document that maintains the original data format, click "RTF format". To create a common text file, to use as a mail merge data source, click the "Microsoft Word merge file" button on the toolbar, as shown in figure 4.
6. In the "file name" box, specify the file name of the new document.
7. If you want to save the document in RTF format and enable Word to open it immediately, select the "auto start" check box.
8. If you want to select a specified data column, select the "select" option.
9. Click the "Export" command to complete the output. In this way, the Access data import is automatically completed in the Word document.
2. Import Word text files to Microsoft Access
1. Save the file as a text file separated by commas (,) or separated by tabs in Word.
2. Switch to MicrosoftAccess and open a new or existing database.
3. Click the "table" tab in the "Database" window.
4. Point to the "get external data" command in the "file" menu, and click "import ".
5. Click the "text file" command in the "file type" box.
6. In the "file name" box, enter the name of the text file to be imported.
7. Click the import command. The import text wizard dialog box is displayed.
8. Follow the instructions in the "Import text wizard" dialog box.
To view more options or modify guides (such as domain separators), click the "advanced" command in the First Wizard dialog box. Here you can adjust the import specifications, 5. If you want to save the specified items so that they can be used when similar text files are imported next time, click the "Save as" command.
The above is an introduction to the data exchange methods between Word2000 and Access2000. In fact, there are many inseparable functions between Office software. If you are a clerk, it will be of great benefit to be proficient in it and use it flexibly.
