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!

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

Exporting Access Report to Excel

Status
Not open for further replies.

PeanutB7

Programmer
Joined
Jun 13, 2005
Messages
56
Location
US
I have created a very complex detailed report in Access Design View and would like to Export it to Excel for storage and adjustments. Regretfully my detailed report comes out as one line with Text Box as the headings and data below. There is no resemblance to my report and nonlegible data as well. I can export to a rich text file and at least it is legible and organized but it appears quite generic as compared to the original document. Any suggestions how to maintain the integrity of the Access Report. Please be aware I am a novice Access person and would kindly request explicit instructions - Pretty Please!

Thank you for your time in advance and have a great day

JB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top