Using an Excel Spreadsheet as A Data source for Miscrosoft Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

solarmfg - 15 Nov 2007 16:13 GMT

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 to this Message

FSt1 - 16 Nov 2007 00:27 GMT

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....data>text to
columns.
that might help.
declare the data range as a named range. this is how excel "sees" it as a
table.

regards
FSt1

> 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
[quoted text clipped - 8 lines]
> recognized as a datasource? Is there a better way to work through the
> parameter delima?

Reply to this Message