Getting data from Access to Excel?

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

How would you go about pulling data from Access database into Excel? (Like
weekly reports)
 
Troy,

Data|Get External Data|New Database Query

Select MS Access Database

The Wizard should take you through the remaining steps of selecting the data
you want to import and the criteria (if any) that you wish to use.

PC
 
You can also push-it-out of Access to Excel by (While in Access) going to
Tools, OfficeLinks... Analyze it with MS Excel.
 
Back
Top