I use to be able to paste a table from Access in to Word.

But something's happened - now the table only displays half
of itself. I change to portrait and set a higher width so there's room for it


all but still no joy

I suspect it's all the wee gagdets, indents and who-knows-what in the line at the top but fiddling with them just makes things worse - although it confirms
the whole table is there.

Can I see it all again pleeassseee !!

Thanks, ABB

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