Link Oracle and Excel

[nuntius007]

I have the following queries and I cannot link them. Can someone show me how to do it?

Regards.

UploadStats:

SQL Select

(to_number(to_char(UPLOAD_DATE, 'DD')) || to_number(to_char(UPLOAD_DATE, 'MM')) || to_number(to_char(UPLOAD_DATE, 'YYYY'))) as Keyfield,

INSTANCE_ID,

ENVIRONNEMENT

from My.OracleTable

Climat:

LOAD

    ([Day] & [Month] & [Year]) as Keyfield,

     [Temp (°C)], [Temp Indicator]

FROM

(biff, embedded labels, table is [fre-hourly$]);

[Gysbert_Wassenaar]

That's probably because the load from oracle will create a field called KEYFIELD instead of Keyfield. Try adding double quotes around the alias:

UploadStats:

SQL Select

(to_number(to_char(UPLOAD_DATE, 'DD')) || to_number(to_char(UPLOAD_DATE, 'MM')) || to_number(to_char(UPLOAD_DATE, 'YYYY'))) as "Keyfield",

INSTANCE_ID,

ENVIRONNEMENT

from My.OracleTable

[sasikanth]

Also try to Store ORACLE table into a QVD and then load this QVD into your application.

[jagan]

Hi,

Oracle select statement will create the columns in Upper case, to bypass this you need to enclose column in double quotes or use preceding load.

UploadStats:

SQL Select

(to_number(to_char(UPLOAD_DATE, 'DD')) || to_number(to_char(UPLOAD_DATE, 'MM')) || to_number(to_char(UPLOAD_DATE, 'YYYY'))) as "Keyfield",

INSTANCE_ID,

ENVIRONNEMENT

from My.OracleTable

Climat:

LOAD

    ([Day] & [Month] & [Year]) as Keyfield,

     [Temp (°C)], [Temp Indicator]

FROM

(biff, embedded labels, table is [fre-hourly$]);

OR

UploadStats:

LOAD

KEYFIELD AS KeyField,

INSTANCE_ID,

ENVIRONNEMENT

SQL Select

(to_number(to_char(UPLOAD_DATE, 'DD')) || to_number(to_char(UPLOAD_DATE, 'MM')) || to_number(to_char(UPLOAD_DATE, 'YYYY'))) as Keyfield,

INSTANCE_ID,

ENVIRONNEMENT

from My.OracleTable

Climat:

LOAD

    ([Day] & [Month] & [Year]) as Keyfield,

     [Temp (°C)], [Temp Indicator]

FROM

(biff, embedded labels, table is [fre-hourly$]);

Hope this helps you.

Regards,

Jagan.

[nuntius007]

Double quotes did work!

Thank you everyone.

Regard!

[jagan]

Hi,

Instead of giving Assumed Answered you would give Correct and Helpful answers to the posts which helps you.  It encourages others to give answers and also easier to find answers for others.

Regards,

Jagan.