Help with MS Access

fjones

Junior Member
Jul 25, 2003
3
0
0
I need to setup a report in MS Access that will print like an Excel Spreadsheet. Or Export data from an Access database into an Excel spreadsheet. Does anybody know how to do this?:confused:
 

NeoV

Diamond Member
Apr 18, 2000
9,504
2
81
you sound like quite the Access newbie...stick with the wizards for now, they are your best bet...you can always just copy/paste data from Access to Excel if you at least no how to use Excel
 

AmerDoux

Senior member
Dec 4, 2001
644
0
71
Once you have your report built in Access, you can just open your report, go to File/Export. In the Save As Type: choose .xl and then Export.
 

BFG10K

Lifer
Aug 14, 2000
22,709
3,007
126
One of the most common ways to bring data from Access into Excel is to bring it into a pivot table.