Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-07-01
6
Medium Priority
?
716 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:Marshall Kass
  • 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:Marshall Kass
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 1600 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 52

Assisted Solution

by:Gustav Brock
Gustav Brock earned 400 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:Marshall Kass
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

963 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