Getting data from Access to Excel?

T

Troy

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

Paul Corrado

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
 
J

JMay

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
How to automate update on weekly reports spreadsheet 0
Help creating a search form in Access XP 0
Excell Otpions in office environment 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Merging from an Excel file with graphics 1
Report Group Footer DLookUp 0
Possible to Combine reports to's to a single box? 0

Top