Office Tips and Hints Blog

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Friday, October 21, 2005 – Permalink –

ACCESS

Drag Data

Simple exchange

To transfer data from an Access query or table in another Office program, such as Word, there's no need to manually export the data.
Open the target Office document

Arrange both applications on the screen
(Right-click an empty part of the Task bar and choose Tile Windows Vertically)

Switch to Access and select the fields or records that you want copied

When you've finished selecting the data, move the mouse pointer near the border of the selection until it turns into an arrow

Finally, drag and drop the data to your target document

You can also select a whole table, go to Edit>Copy. Switch to Word or Excel and Paste.

It works in the other direction too. Select some Excel data. Switch to Access.

While viewing the Tables Objects, Paste the Excel data. It will form a new table.

See all Topics

<Doug Klippert@ 6:12 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>

<$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link