Book

Suggestions


Enter your email address:

Delivered by FeedBurner



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












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Monday, December 29, 2008 – Permalink –

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.
  1. Open the target Office document

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

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

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

  5. 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

Labels: , ,


<Doug Klippert@ 3:57 AM

Comments: Post a Comment