On Sep 30, 9:42*pm, FSt1 wrote:
hi
the guts of Microsoft Query (MSQ) is ODBC and the language behind it is SQL.
it is just conveniently packaged as a MS Wizard ie point and click.
can you say the words "recorded macro"?
tell us more about *this "searching keywords is pretty cumbersome" so that
we might better understand what the problem is and perhaps what you are
trying to accomplish?

regards
FSt1

" wrote:
Is it possible to run 2007 excel MS Query on an Excel spreadsheet with
the same results as if you'd run it on an ODBC table like SQL? *I have
an export from a data table into an Excel spreadsheet and searching
keywords is pretty cumbersome so I was hoping that MS Query might
yield a better result. * TIA

If you copied and pasted (or exported the contents of a DB table) into
an Excel spreadsheet, you'd have 1000 records with a lot of various
text populated in the fields and want to find only the word
"FSt1" (and only have those instances show up in the MS Query). One
other way to do this would be to use the Ctrl F key and 'find' your
way through the various records but I'd hoped to get something similar
to what you might find when you *filter* info which seems a bit more
straight forward. This is actually a MySQL DB table by the way and
the SysAdmin is concerned over what might happen if someone were
writing to the DB table when a query were being run so is inclined to
ask that the data be exported to an Excel spreadsheet and used or
manipulated from there.