Thread: External data query - need to use SELECT * (ALL RECORDS)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Vladimir Rakic Vladimir Rakic is offline
external usenet poster
  
Posts: 1
Default 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!
Reply With QuoteReply With Quote