• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Exhanging Data Annoyances > MS QUERY AND DATABASE ANNOYANCES

MS QUERY AND DATABASE ANNOYANCES

BRING IN SELECTED DATABASE RECORDS

The Annoyance:

I'm pretty good at using Excel, but I've never had to do anything more than copy and paste rows from an Access database table into my worksheets. Now I'm faced with bringing thousands of database records into Excel. How do I get Excel to do the picking and choosing for me?

The Fix:

First off, don't copy the entire table into Excel and then try to wrestle the data into some sort of shape! You want to narrow down the data to a manageable set, which is exactly what Microsoft Query was designed for. It lets you create and run queries in other database and spreadsheet programs, pull that information into Excel, and format it as you wish. You can find Microsoft Query on your Office installation disk. If you don't already have Query installed in Office 2002 (aka Office XP) or 2003, choose Data → Import External Data → New Database Query—normally the sequence to launch Microsoft Query. Put your Office installation CD into your drive when prompted and Office will do the rest. In Excel 97 and 2000, when you try to create a new query without Microsoft Query installed you'll get an error message telling you to install it yourself. Hmph...how rude. But here's how to do it in Excel 97:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint