Insert access, SQL database data in Word

The easiest way for word to share access data is to copy, paste, and you can simply open the table in the Access database and copy the Access data as you would copy the Excel data and paste it into Word. In addition, Word can use the method of inserting records to share access, SQL data.

1. Insert All records

Right-click the Word toolbar, select database, open the Database toolbar, click the Insert Database button, click the Get Data button in the Open Database dialog box, and double-click the Access database in the Open dialog box.

If you need to insert some or all of the data in your database into Word, you can click Get data in the Database dialog box, select a data source, click Insert Data in the Database dialog box, select the all or from option in the Open dialog box, and click OK button to insert the record data into the document.

2, insert the record that meets the condition

If we need to insert a record in a database that matches certain criteria into the document, use query options for the necessary filtering, open the Database dialog box, and click the Query Options button to open the corresponding dialog box.

In the dialog box, enter fields, compare conditions, and compare objects.

You can also insert records from an Excel worksheet into Word using the above description.

3. SQL data connection

Typically, we use the Acces database. If Word needs to share data from SQL Server 2000 and other databases, you need to use the Data Connection Wizard. This can only be described briefly.

On the Word Database toolbar, click the Insert Database button, in the Open Database dialog box, click Get data, and in the Open dialog box, click the New Source button to open the Data Connection Wizard.

Select the Microsoft SQL Server option and click the Next button to open the dialog box. Enter the name of the server, login credentials, click Next, select the table to which you want to insert data, click the Next button to continue, and in the Open dialog box, list the name of the data connection file that you are about to create, and click the Finish button.