Thread: [Solved] Help With Table
View Single Post
 
Old 12-13-2010, 02:46 PM
atrivedi atrivedi is offline Windows 7 Office 2010 (Version 14.0)
Advanced Beginner
 
Join Date: Sep 2010
Posts: 37
atrivedi is on a distinguished road
Default

Using the Clipboard feature in Word makes this task easier.

To copy data from Access to a Word table, using the Clipboard do the following:

1. In Access, select all the data in the resulting query (or table).

2. Select all the records by clicking the intersecting header cell at the top-left corner, or by pressing [Ctrl]+[A].

3. Press [Ctrl]+[C] to copy the selected data to the Clipboard.

4. Open a new Word document.

5. Choose Paste Special from the Edit menu. In Word 2007, choose Paste Special from the Paste command’s dropdown list. You’ll find the Paste command in the Clipboard group on the Home tab.

6. In the resulting Paste Special dialog box, click Unformatted Text, and then click OK.

7. Now that you have the data in Word, you can quickly insert a Word table. In the Word document, select all the data by pressing [Ctrl]+[A].

8. Choose Convert from the Table menu and then select Text to Table from the resulting submenu. In Word 2007, you’ll find this command in the Table command’s dropdown list. The Table command is in the Tables group on the Insert tab.

9. Click OK to insert the table.

Hope this helps.

A. Trivedi
Reply With Quote