Error trying to export from an older access database(using Access 2007) to excel spreadsheet
Posted on 2009-07-01
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:
Macro Name: ExportToExcel
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.