Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2007: Export report to Excel 1

Status
Not open for further replies.
BlueHorizon

BlueHorizon

Instructor
Jan 16, 2003
730
US
Hi all!

I was always able to export a report to Excel in v2003. I'm unable to find how to do this in 2007.

Anyone?

Best,
Blue Horizon [2thumbsup]
 
Sort by date Sort by votes
Found my answer! While you cannot export a report directly to Excel in 2007, you can create a query using all fields from the report, and export that directly to Excel.
HTH,

Best,
Blue Horizon [2thumbsup]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
110
GPnew
GPnew
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
522
renigar
renigar
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
269
dhookom
dhookom
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
871
EwaFAMA
EwaFAMA
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
254
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top