R
ramz
So, I'm attempting to grab a subset of data from one master
spreadsheet based on the value of a cell in a specific row to
determine if it should be imported or not. I've managed to create the
connection which imports the entire table, but short of using
filtering in the importing sheet (which won't work for my purposes
because I need to do sum operations and such and the filtering only
seems to hide the rows I don't want but does not exclude data found
therein when range sums are used) I can't seem to figure out a way to
make the data connection do the filtering for me. Being that this
seems to use SQL language (and mind you, I'm not an SQL expert, but I
have picked up a few phrases along the way) I would think that I could
type something like this in the "Command Text" box in the Definition
tab of the Connection Properties dialog:
SELECT * FROM [Sheet1$] WHERE < range or column or whatever > = '<
VALUE >'
I *think* the problem is that I can't find documentation that would
tell me what the syntax of the "< range or column or whatever >" bit
would actually be. I've tried a zillion different things to no avail.
Could someone point to some documentation or provide some insight on
getting this working? Thanks!
spreadsheet based on the value of a cell in a specific row to
determine if it should be imported or not. I've managed to create the
connection which imports the entire table, but short of using
filtering in the importing sheet (which won't work for my purposes
because I need to do sum operations and such and the filtering only
seems to hide the rows I don't want but does not exclude data found
therein when range sums are used) I can't seem to figure out a way to
make the data connection do the filtering for me. Being that this
seems to use SQL language (and mind you, I'm not an SQL expert, but I
have picked up a few phrases along the way) I would think that I could
type something like this in the "Command Text" box in the Definition
tab of the Connection Properties dialog:
SELECT * FROM [Sheet1$] WHERE < range or column or whatever > = '<
VALUE >'
I *think* the problem is that I can't find documentation that would
tell me what the syntax of the "< range or column or whatever >" bit
would actually be. I've tried a zillion different things to no avail.
Could someone point to some documentation or provide some insight on
getting this working? Thanks!