Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Running MS Query on an Excel Spreadsheet
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Running MS Query on an Excel Spreadsheet
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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Running MS Query on an Excel Spreadsheet
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. |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Running MS Query on an Excel Spreadsheet
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 " wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
Long time to open spreadsheet (running Excel 2007) | Excel Discussion (Misc queries) | |||
Help on Running Query | Excel Discussion (Misc queries) | |||
Running Query | Excel Worksheet Functions | |||
Running Access Query from Spreadsheet | Excel Discussion (Misc queries) |