Running MS Query on an Excel Spreadsheet


J

jcage

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
 
Ad

Advertisements

F

FSt1

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
 
J

jcage

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

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.
 
Ad

Advertisements

F

FSt1

hi again,
sound like you want a MSQ parameter query where you supply info so that the
MSQ only returns info you are interested in.... sort of like filtering.
but to create a parameter query, you must create the query first. for some
reason MS desided that you can't have a paramerter query until you have a
query. wierd.
follow the wizard to create the query and once the query is created (data in
excel), right click the query range, and click parameters. follow the wizard.
after that you should be prompted to supply the info you are interested in.
and since you can run the query (refresh) anytime you want, you can plug in
any parameter you want over and over. but the parameter keys on one field. if
you want to search miltiple field, you may need to have multiple MSQ's.
been there...done that. yeah... a hassel. but....... thus is the world of
data management. fun huh.

regards
FSt1


regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top