Another problem with Excel SQL

More
12 years 7 months ago #1813 by George
Dear Support

Many thanks for your help so far.

I have another question, on this same spreadsheet, how do I use the content of cell A12 to add to each record? The following SQL extracts A12 successfully
Select "Notification$Print_Titles[A11:A12]".* From "Notification$Print_Titles$A11:A12]"

but can't work out how to include it in the original query:

Select
"Notification$Print_Titles"."Destination",
"Notification$Print_Titles"."Minute",
"Notification$Print_Titles"."Remark",
"Notification$Print_Titles"."Prefix"
From
"Notification$Print_Titles"


regards,
George

Please Log in or Create an account to join the conversation.

More
12 years 7 months ago #1814 by admin
Try this one

Select
"Notification$Print_Titles"."Destination",
"Notification$Print_Titles"."USD/Minute",
"Notification$Print_Titles"."Remark",
"Notification$Print_Titles"."Prefix",
"Notification$Print_Titles[A11:A12]".*
From
"Notification$Print_Titles",
"Notification$Print_Titles$A11:A12]"

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
12 years 7 months ago #1815 by George
Yes it works now
Thank you,
George

Please Log in or Create an account to join the conversation.