Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Urgent help with exporting report to excel

Urgent help with exporting report to excel

Urgent help with exporting report to excel


I need urgent help here. I have a question on the microsoft access. What's happening is that i have a form that can allow user to view report, print report and export to excel.

The report is a bit nasty in a sense that it's been arranged or formatted in a way that looks more professionall or advance. It's got report heading, other headings, columns, number of rows. So it looks like a real report. Now, i know how to export report to excel but what i don't know and have never done before is to export such report to excel and make the excel looks similar to the report.

So my question is is it possible? what do i have to do to make it happen?


RE: Urgent help with exporting report to excel

Yes - simple via VBA. Do it as a 'pull' from Excel rather than a 'push' from Access. Don't forget that you're limited to 32k rows in Excel!

Good Luck
To get the best from these forums read FAQ731-376 before posting

Steam Engine enthusiasts: www.essexsteam.co.uk

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close