?
Solved

Convert Access 2003 to 2007

Posted on 2007-12-04
6
Medium Priority
?
1,181 Views
Last Modified: 2012-06-27
I wrote a database in Access 2003. All was working. I exported a report into Excel 5 format. With the upgrade to 2007 I get the mesage: "The format in which you are attempting to output the current object is not available".
I checked the References and all required references are checked vers.12 now.
What do I have to do?
Josh
0
Comment
Question by:liketoknow
  • 3
  • 3
6 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 20402095
Hi liketoknow,

Sorry ...In 2007 you can no longer output reports to Excel.(only forms ,Tables etc)

Good Luck!

Gary
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 20402097
0
 

Author Comment

by:liketoknow
ID: 20402246
Hi tbsqadi,
I use a report to transfer data into an Excel file, manipulate it and save the Excel file on drive. The same in reverse direction. How is it done in Access 2007 ?

Best regards Josh
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 46

Accepted Solution

by:
tbsgadi earned 375 total points
ID: 20402256
Either from a form or from a query
0
 

Author Comment

by:liketoknow
ID: 20402984
What are the guys at Microsoft thinking???

I have to look deeper into that stuff. My client upgraded the software and I am behind (still using 2003). Until I upgraded I am not be able to fix the issue.

Thanks alot.
Josh
0
 

Author Comment

by:liketoknow
ID: 20449699
How are you guys discussing this stupid stuff with your customers? Spending quiet some time and money to get it to work and then suddenly: IT"S OVER!
All this neat stuff, now I have to start over again incl. trouble shooting.......

Will Microsoft ever go a step forward?
Any experience with LINUX or OpenOffice, regarding Database?
Thanks Josh
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

598 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question