Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using an Excel Spreadsheet as A Data source for Miscrosoft Query
I am getting data using microsoft query from a flat file database, but
because I am using a query that can not be graphically displayed, it will not let me pass a parameter to the query. In frustration, I have dumped all the data to an excel spread sheet (Open Orders.xls) and would now like to just get the records I want (where item_number = <user_input). I tried to set up an excel spreadsheet (Open Orders.xls) as a data source for microsoft query, by selecting new data source Excel and the name of the workbook (Open Orders.xls). When Microsoft Query opens up, it does not show any tables. I was under the assumption that each worksheet would be treated as a table. Do I need to do something special when saving the excel work so that it will be recognized as a datasource? Is there a better way to work through the parameter delima? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using an Excel Spreadsheet as A Data source for Miscrosoft Query
hi
i have never done this with flatfiles before but you can use xl as a data sorce. how are you passing the parameter. did you parse the data in the OpenOrder.xls. on the menu....datatext to columns. that might help. declare the data range as a named range. this is how excel "sees" it as a table. regards FSt1 "solarmfg" wrote: I am getting data using microsoft query from a flat file database, but because I am using a query that can not be graphically displayed, it will not let me pass a parameter to the query. In frustration, I have dumped all the data to an excel spread sheet (Open Orders.xls) and would now like to just get the records I want (where item_number = <user_input). I tried to set up an excel spreadsheet (Open Orders.xls) as a data source for microsoft query, by selecting new data source Excel and the name of the workbook (Open Orders.xls). When Microsoft Query opens up, it does not show any tables. I was under the assumption that each worksheet would be treated as a table. Do I need to do something special when saving the excel work so that it will be recognized as a datasource? Is there a better way to work through the parameter delima? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I've inharited a spreadsheet that I need to change the query to an external source... | Excel Discussion (Misc queries) | |||
Changing ODBC data source for a query embedded in Excel | Excel Discussion (Misc queries) | |||
excel chart with data source from an access query | Charts and Charting in Excel | |||
Excel data query locks source file | Excel Discussion (Misc queries) | |||
Excel - MS Query - changing location of Access data source | Excel Programming |