Access export to excel bug

My apologies for crossposting this, but I did not get any response in
microsoft.public.access

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/4929214ae589afd9/b11bf56313b894d4?lnk=st&q=access+export+to+excel#b11bf56313b894d4

The specific problem is mentioned in the above post, but here is a
basic description of the problem.

When using saved queries that are used as part of a union query, the
UNION query does not export to excel successfully and prompts the user
to "enter parameter value" when no parameters are used. However, the
query works correctly when you simply run it in access, and it is
possible to export to other formats, but it consistently fails when
exporting to excel.

I know the description in my previous post is rather long, but I
wanted to provide as much information as I could.

If anyone has any ideas, can reproduce the error, or can point me to
someplace where I can submit this to Microsoft, I would appreciate it.

Thank you.
.

Relevant Pages

  • Re: Crosstab queries
    ... In the Union query, I end up with the "Response" colum that contains all ... Tom ... >>> Duane Hookom ...
    (microsoft.public.access.queries)
  • Re: Help w/ Union Queries
    ... There are lots of people who use access that frequent these Excel newsgroups. ... The response back suggested I make a union query to do this. ...
    (microsoft.public.excel.misc)
  • Re: Extract data to new fields
    ... Currently the field Q1 holds the response and the Field ... >select SurveryId, Q1 as Question, Response from ... the union query into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Union query not working properly if no records exist
    ... Apologies for not getting back ... being generated by a cross tab query. ... the union query returns the following error ... The Microsoft Database engine does not ...
    (microsoft.public.access.queries)
  • Re: counting the number of responses
    ... You could try normalize your table structure with a union query. ... Then create your totals query ... SELECT Question, Response, Countas NumOf ...
    (microsoft.public.access.queries)