close

Hi

Rathey than simply copy paste is there anything in Excel similar to MS Access?

In MS Access if you highlight a table.
Then the Menu bar the office links gives you the option to -
-Merge it with Microsoft Word
-Publish it with Microsoft Word
-Analyse it with Microsoft Excel

The second option is a very neat way to get Excel into Word

Thanks

Jay

From Publisher 2003 Help.............

Export text
Although you cannot export directly from Microsoft Publisher, you can cut and
paste all or part of the text in a publication to a document in another
application. You can also save the publication in a different file format to
use in the other application.

On the File menu, click Save As.
In the File name box, type a name for the text.
In the Save as type box, click the file format used by the other program.
If you don't know the format, click either Rich Text Format or Plain Text.

Click Save.
Open the program and document to which you want to add the text.
Add the text you've saved by using the Insert Text, Import Text, Insert File,
or Open command of the program.

..............................

Unfortunately, Excel is not one of the file formats so go with the copy and
paste or save as a *.txt file and open that with Excel.Gord Dibben Excel MVP

On Fri, 23 Dec 2005 01:32:02 -0800, Jay gt; wrote:

gt;Hi
gt;
gt;Rathey than simply copy paste is there anything in Excel similar to MS Access?
gt;
gt;In MS Access if you highlight a table.
gt;Then the Menu bar the office links gives you the option to -
gt;-Merge it with Microsoft Word
gt;-Publish it with Microsoft Word
gt;-Analyse it with Microsoft Excel
gt;
gt;The second option is a very neat way to get Excel into Word
gt;
gt;Thanks
gt;
gt;Jay

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()