- Posts: 51
- Thank you received: 0
Another problem with Excel SQL
12 years 7 months ago #1813
by George
Another problem with Excel SQL was created 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
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.
12 years 7 months ago #1814
by admin
Mike
ETL Architect
Replied by admin on topic Re: Another problem with Excel SQL
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
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.
12 years 7 months ago #1815
by George
Replied by George on topic Re: Another problem with Excel SQL
Yes it works now
Thank you,
George
Thank you,
George
Please Log in or Create an account to join the conversation.