Software

General discussion

Access 2000 problem exporting to Excel

Working on Access 97 I used to export a particular report to Excel by right clicking on the Print Preview screen and exporting to Excel. The report in question had 'Totals' and these would also get exported to Excel correctly.

I have converted the database in question to Access 2000 and am now having a problem: -

When I run the report there is no longer a right click option to export - this is now covered by the Analyse with Excel export option - However, I am finding that although my data in question comes across okay, the Totals within the Access spreadsheet do not come across.

All Comments

Access 2000 problem exporting to Excel

I do not get the same options you do when I right-click on the print preview window of a report. The "Export ... " choice is there, and the "Export Report (Name) to ..." window appears. All that is necessary is to choose the "Save As type" Excel instead of the default Access .mdb format.

I have checked the "Options" in the Tools menu, and I do not see anything that should make this change in the way Access 2000 works. Is there any possibility that something in the installation was different than the Standard full installation?

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.