MS Excel and DB2 select with AS

[mcauliff]

Is it possible to code an db2 select in the Microsoft Query function of Excel with the AS clause?

Example

Select last_name || ',' || first_name AS Name, address
from address
where last_name = 'Jones'

Does the 'AS Name' work in Excel?

 

[SkipVought]

Hi,

MS Query (not Excel) does not like alias names when you code SQL from DB2 or Oracle.

You can, however, use ADODB and VBA to query using aliases. Please post in forum707, if you want some help in that direction.

BTW, you can always assign MS Query, Data Range Properties to NOT return field headings and assign them yourself.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mcauliff]

Skip

Thanks for the reply. I thought that it didn't allow for it. I wanted to make sure. This is suppose to be a onetime thing.

I keep in mind using VBA for future reference.