Exporting Union Query to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following union query:

SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "Datamart" AS
[Source]
FROM Datamart
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;

The problem is that I am trying to import this data to excel and I get a
message stating that Too few parameters. Any tips are greatly appreciated!!
 
* Have you checked and make sure all the Field names & Table names are
correct? An incorrect name is usually treated a a Parameter and you will
get the error message posted.

* Some of the names you used are keywords / reserved words (Date, Group).
Change the Field names if you can. If you can't, make sure you use square
branckets to denote names rather than key/reserved words.
 
Also, I'm not sure that the square brackets around Source are correct.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Van T. Dinh said:
* Have you checked and make sure all the Field names & Table names are
correct? An incorrect name is usually treated a a Parameter and you will
get the error message posted.

* Some of the names you used are keywords / reserved words (Date, Group).
Change the Field names if you can. If you can't, make sure you use square
branckets to denote names rather than key/reserved words.

--
HTH
Van T. Dinh
MVP (Access)




Michael said:
I have the following union query:

SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "Datamart" AS
[Source]
FROM Datamart
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;

The problem is that I am trying to import this data to excel and I get a
message stating that Too few parameters. Any tips are greatly
appreciated!!
Click to expand...
Click to expand...
 
That's one is OK, Doug.

Alias is a name so the square brackets are valid delimiters. I did a quick
test in A2003 also.
 
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;
Click to expand...

should probably be

UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM" AS
[Source]
FROM eWFM;

HTH,
--
George Nicholson

Remove 'Junk' from return address.


Michael said:
I have the following union query:

SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "Datamart" AS
[Source]
FROM Datamart
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;

The problem is that I am trying to import this data to excel and I get a
message stating that Too few parameters. Any tips are greatly
appreciated!!
Click to expand...
 
Actually, that's unlikely to be the problem: the names of the fields do not
have to agree between the subselects as long as the number of fields and
their types correspond.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



George Nicholson said:
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;
Click to expand...

should probably be

UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM" AS
[Source]
FROM eWFM;

HTH,
--
George Nicholson

Remove 'Junk' from return address.


Michael said:
I have the following union query:

SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "Datamart" AS
[Source]
FROM Datamart
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;

The problem is that I am trying to import this data to excel and I get a
message stating that Too few parameters. Any tips are greatly
appreciated!!
Click to expand...
Click to expand...
 
What's the point of the aliasing at all in this query?

Michael said:
I have the following union query:

SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "Datamart" AS
[Source]
FROM Datamart
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;

The problem is that I am trying to import this data to excel and I get a
message stating that Too few parameters. Any tips are greatly
Click to expand...
appreciated!!
 
Doug

IIRC, the types of the corresponding Fields don't have to be the same
either. If Access can assign the combined Field / Column to a strong type,
it will nominate the Column type as Variant.

I think the only requirement in a Union Query is that the number of Fields
in each Select clause must be the same.
 
.... and, of course, I meant to write:

"... . If Access canNOT assign ... "
 
My bad. I should have tested before I posted.

I know that the names of fields don't need to match, just the number of
fields. What I *didn't* know was that 'eWFM' would evaluate the same as
'eWFM as SomeAlias" in the query output. I was thinking (erroneously) that
Jet wouldn't know what to make of "eWFM" without "As SomeAlias" and generate
an error because it thought the # of fields were unequal.

It's a good way to end the week: learn something new...

--
George Nicholson

Remove 'Junk' from return address.


Douglas J. Steele said:
Actually, that's unlikely to be the problem: the names of the fields do
not have to agree between the subselects as long as the number of fields
and their types correspond.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



George Nicholson said:
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;
Click to expand...

should probably be

UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM" AS
[Source]
FROM eWFM;

HTH,
--
George Nicholson

Remove 'Junk' from return address.


Michael said:
I have the following union query:

SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "Datamart" AS
[Source]
FROM Datamart
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;

The problem is that I am trying to import this data to excel and I get a
message stating that Too few parameters. Any tips are greatly
appreciated!!
Click to expand...
Click to expand...
Click to expand...
 
What's the point of the aliasing at all in this query?

The [Source] field in the output will specify which table the record came
from.

Can be very handy. Example: Unioning "Budget" and "Actual" data and being
able to easily create a cross-tab from the results. Also makes debugging
easier.

--
George Nicholson

Remove 'Junk' from return address.


MacDermott said:
What's the point of the aliasing at all in this query?

Michael said:
I have the following union query:

SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "Datamart" AS
[Source]
FROM Datamart
UNION SELECT ID, CRC, Supervisor, Manager, Date, Group, Hours, "eWFM"
FROM eWFM;

The problem is that I am trying to import this data to excel and I get a
message stating that Too few parameters. Any tips are greatly
Click to expand...
appreciated!!
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union Query 4
Union Queries 4
Union Queries - Column Headers 3
Union Query Where Clause 0
UNION query question 7
"Enter parameter value" error when exporting to Excel 0
Union query Problem? 1
Trouble with a union Query 2

Back
Top