Solved

Error trying to export from an older access database(using Access 2007) to excel spreadsheet

Posted on 2009-07-01
6
615 Views
Last Modified: 2013-11-27
We have an older access database (2000/2003 not sure) and a computer with office 2007.  When we try to use the export function from this PC we get the following error:
"The format in which you are attempting to output the current object is not available"  Either you are attempting to output the current object to a format that is not valid for its object type, or the formats that enable you to output data as a microsoft excel, rich text format, ms dos text, or html file are missing from the windows registry.  Run setup to reinstall ms office access or, if you are familiar with the settings in the registry, try to correct them yourself."
Then after we click OK, we get the following dialog box from Access:
ACTION FAILED:
Macro Name:  ExportToExcel
Condition: True
Action Name: OutputTo
Arguments: 1, ComboSearchResults, MicrosoftExcel(*.xls), N:\AeroDocs\Aero Design Documents\Technical Documents\Tech Database\DB_Results.xls, Yes, , ,

Error # 2950

We are using office 2003 on all other PCs and are experiencing NO problems.  Is this a macro issue or is there something missing from this version of Access 2007 professional which we need to install or reinstall?

PS This is a closed application - I do not know where to find the macro to show the code.
0
Comment
Question by:Marshalk
  • 3
  • 2
6 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24759399
Is the machine having the problem at the same Service Pack level asa all the other machines? (for Office and Windows)
0
 

Author Comment

by:Marshalk
ID: 24759448
this is the only PC we are running office 2007 on.  The others are running 2003 pro.  My customer purchased and installed this without my knowledge , we just ordered 5 more copies and he told me about this issue after the order was completed.  So no, it is the XP Pro SP3 but a different version of office.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 400 total points
ID: 24760169

Try creating a Blank Access 2003 database *in Access 2003*.
Then importing all of the objects into it.
Then use this as the new standard db that all the computers run.

Then report back.

0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 100 total points
ID: 24765496
Run the Office 2007 install again, select "Custom", and mark all relevant im- and export (data) formats for Access and Excel (- can't remember the exact options).

/gustav
0
 

Author Closing Comment

by:Marshalk
ID: 31604216
I actually found the solution in another of boaq2000's answers (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24503876.html) and applied it here.  I split the points as you were both helping, and I appreciated your responses.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24869536
<I actually found the solution in another of boaq2000's answers (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24503876.html) and applied it here.>
Thanks.

I am gald to see that a previous solution of mine helped you.
;-)

Jeff
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

707 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now