Link to home
Start Free TrialLog in
Avatar of Marshall Kass
Marshall KassFlag for United States of America

asked on

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

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.
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Is the machine having the problem at the same Service Pack level asa all the other machines? (for Office and Windows)
Avatar of Marshall Kass

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I actually found the solution in another of boaq2000's answers (https://www.experts-exchange.com/questions/24503876/Access-2007-exports-to-Excel-in-Compatibility-Mode.html) and applied it here.  I split the points as you were both helping, and I appreciated your responses.
<I actually found the solution in another of boaq2000's answers (https://www.experts-exchange.com/questions/24503876/Access-2007-exports-to-Excel-in-Compatibility-Mode.html) and applied it here.>
Thanks.

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

Jeff