J
Jason Krug
Hello-
I am trying to find several workarounds for another
posting I have, when I came up with this idea.
I put SALES data in an Access Table
DAY CAT SKU AMT
1/1/3 1 1A 1.1
1/1/3 1 1B 1.2
1/1/3 2 2A 2.1
1/2/3 1 1A 1.1
etc.
In Excel, I dynamically pulling selected data out, based
upon values entered in the Excel Sheet
Enter CAT = 2
Enter START DATE = 1/1/3
Enter END DATE =1/1/3
Should result in only:
1/1/3 2 2A 2.1
I have labeled these all with a name, as if a table, so I
can"
SELECT START_DATE FROM C:/Daily/MY.XLS!SELECTED_VALUES.
When I try to build the query in MS QUERY, you have to
select DATA SOURCE... either an XLS or MDB.
When I choose MDB, it cannot find the XLS SELECT_VALUES
table, since it is not in the database. When I select
XLS, it cannot find DATABASE.XLS. When I tried to put an
extension into the file names, I received a parsing
error, and it would not even execute the SQL. It seems
they must be ALL the same type.
Here is the SQL QUERY:
SELECT DailyPOS.Date, DailyPOS.`Subcat Nbr`,
DailyPOS.`Vendor Stock Nbr`, DailyPOS.`Total Sell Dollars`
FROM `U:\ Daily\Data-RetailLInk`.DailyPOS DailyPOS
WHERE (DailyPOS.Date>=
(SELECT MIN(ForQuery.TY)
FROM `U:\ Daily\TY-scorecardtemplate`.ForQuery ForQuery))
Any thoughts?
--Jason
I am trying to find several workarounds for another
posting I have, when I came up with this idea.
I put SALES data in an Access Table
DAY CAT SKU AMT
1/1/3 1 1A 1.1
1/1/3 1 1B 1.2
1/1/3 2 2A 2.1
1/2/3 1 1A 1.1
etc.
In Excel, I dynamically pulling selected data out, based
upon values entered in the Excel Sheet
Enter CAT = 2
Enter START DATE = 1/1/3
Enter END DATE =1/1/3
Should result in only:
1/1/3 2 2A 2.1
I have labeled these all with a name, as if a table, so I
can"
SELECT START_DATE FROM C:/Daily/MY.XLS!SELECTED_VALUES.
When I try to build the query in MS QUERY, you have to
select DATA SOURCE... either an XLS or MDB.
When I choose MDB, it cannot find the XLS SELECT_VALUES
table, since it is not in the database. When I select
XLS, it cannot find DATABASE.XLS. When I tried to put an
extension into the file names, I received a parsing
error, and it would not even execute the SQL. It seems
they must be ALL the same type.
Here is the SQL QUERY:
SELECT DailyPOS.Date, DailyPOS.`Subcat Nbr`,
DailyPOS.`Vendor Stock Nbr`, DailyPOS.`Total Sell Dollars`
FROM `U:\ Daily\Data-RetailLInk`.DailyPOS DailyPOS
WHERE (DailyPOS.Date>=
(SELECT MIN(ForQuery.TY)
FROM `U:\ Daily\TY-scorecardtemplate`.ForQuery ForQuery))
Any thoughts?
--Jason