View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Candyman Candyman is offline
external usenet poster
 
Posts: 66
Default Multiple External Data Returns

I have an SQL statement that return 3 sets of data to an SQL editor. Each
Statement is separated by a semi-colon. Not all statements have equal titles
or columns. Is there a way to return the three sets in one get external Data
action or do i have to loop through the SQl three time?

My code currently builds the SQL Statement from start to finish and runs
fine for standard returns, but only lists the data return for the first data
set. Is this a limitation with Excel or can I return all 3 data sets in one
shot? In other words do i need to code some sort of looping?

Thanks!