keiranwyllie
New Member
- Joined
- May 12, 2017
- Messages
- 47
Morning all,
I have a question regarding SQL queries when creating a data connection. I have created a data connection to an external workbook to a sheet that has a table in it. This table starts at row 13 (the headers) and is a dynamic table that gets updated from time to time.
In my query, I've tried:
Select * from [Sheet1$] where column4 ="Name" (This gives the error "No value given for one or more required parameters" which I think relates to the table not starting on row 1)
Select * from [Sheet1$.A13:Q10000] where column4 ="Name" (This gives a "could not find the object 'Sheet1$.A13:Q10000'. Make sure the object exists" error)
I know the data exists etc but I'm just having trouble retrieving the data (again I think it's because the table doesn't start at row 1).
Any thoughts or suggestions would be greatly appreciated.
K.
I have a question regarding SQL queries when creating a data connection. I have created a data connection to an external workbook to a sheet that has a table in it. This table starts at row 13 (the headers) and is a dynamic table that gets updated from time to time.
In my query, I've tried:
Select * from [Sheet1$] where column4 ="Name" (This gives the error "No value given for one or more required parameters" which I think relates to the table not starting on row 1)
Select * from [Sheet1$.A13:Q10000] where column4 ="Name" (This gives a "could not find the object 'Sheet1$.A13:Q10000'. Make sure the object exists" error)
I know the data exists etc but I'm just having trouble retrieving the data (again I think it's because the table doesn't start at row 1).
Any thoughts or suggestions would be greatly appreciated.
K.
