Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data query - need to use SELECT * (ALL RECORDS)
I have a query that will expand every month to include all monthly
data. How can i modify my existing data query to include SELECT * (for all records), instead of adding a column every month ? Thanks, Vlad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data query - need to use SELECT * (ALL RECORDS)
Use a defined name for the range like
On the sheet where you want the nameinsertnamedefinetype in something like Select in the refers to box type in =offset($a$1,0,0,0,counta($1:$1)) For more info on this look in HELP index for OFFSET -- Don Guillett SalesAid Software "Vlad" wrote in message om... I have a query that will expand every month to include all monthly data. How can i modify my existing data query to include SELECT * (for all records), instead of adding a column every month ? Thanks, Vlad |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data query - need to use SELECT * (ALL RECORDS)
I am using the OFFSET to specify target name range, but the query
definition (Excel's MS Query) still selects individual columns eg. "Select qry.Column1, qry.Column2 from qry" , instead of "Select * from qry ". Is there a way to specify SELECT * (ALL) in the Get External Data Qry definition ? Vlad Rakic Sydney, OZ *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data query - need to use SELECT * (ALL RECORDS)
Your table gets a new column every month?! Sounds like bad database
design. Treat the problem, rather than the symptoms: redesign your database schema. -- (Vlad) wrote in message . com... I have a query that will expand every month to include all monthly data. How can i modify my existing data query to include SELECT * (for all records), instead of adding a column every month ? Thanks, Vlad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep cell data with records from a query | Excel Discussion (Misc queries) | |||
External Data Query | Excel Discussion (Misc queries) | |||
Get External Data-New Web Query | Excel Discussion (Misc queries) | |||
Query of External Data | Excel Discussion (Misc queries) | |||
Get External Data Query | Excel Programming |