Access 2007

[Bunert]

I have an Access 2000 database that I am converting to Access 2007. It has
several forms and coding behind it that I am working through.

Ran into one issue that I didn't think would be a problem,

I have a line

docmd.outputto acoutputreport, "rptname", acformatxls, "c:\folder\file.xls",
false

it returns an error that says

"the format in which yoiu are attempting to output the current object is not
available"

any tips?

it appears in Access 2007 that one can no longer export a report to Excel??
Is that right?? Even in code?? wow?!?

 

[Allen Browne]

It seems that A2007 can export a table or query to Excel, but not a report.

Previous versions could export the report, but in A2007 I am seeing Error
2282:
The format in which you are attempting to output the current object
is not available.

SendObject fails in the same circumstances, so this does seem to be a
limitation of the new version that is not documented and will affect quite a
number of people.

 

[Bunert]

Thanks for the confirmation.

I don't know what these means to everyone else, but its a huge issue for us.
We're a small manufacturing company and have 100-200
programs/forms/reports/etc that do the export report to Excel. Its either a
huge time issue to reprogram to write it all to table or saved queries on
the fly in order to upgrade or its a big cost to pay someone to do the
conversion. Neither of which is realistically possible for a small company
like us. These were programs/reports built over the years and right or wrong
they mostly export reports to excel. Unfortunately, we had planned an end of
Q1 upgrade to Office 2007 but this will put the skids on that.

Anyone else in the same boat? How you you handling?

 

[Guest]

I've just run into that same problem, which is going to break an automated
system we've happily had in place for a number of years.

I realize that the report export to Excel was not perfect - those of us
using it have known that and can deal with it.

My questions are these:

For Microsoft:
Are you planning an add-in to address this issue?

For Everybody:
Has anybody come up with any viable workarounds? I've thought of exporting
a report as text and then programmatically building an Excel spreadsheet, row
by row, via automation, based on the text output. I'm sure that the results
would probably be marginal, but it's one of relatively few options. Yes, you
can export as XML and import that to Excel, but the results are just as
minimal as that which you'd get from exporting just the data from the query
or table underlying the report - something you can still export directly to
Excel format anyway.