C# Excel multiple cell/column/row SQL Query Question

[rise4peace]

Howdy,

I am trying to select a range of data within an excel spreadsheet using
a SQL query. The two queries below do the trick but I was wondering if
there's any way to combine both of these SQL queries into one query?

SELECT * FROM [Retail @home$A11:H46]
SELECT * FROM [Retail @home$J12:Q46]

It looks to me like trying to do multiple column/row selects in one
statement is not possible but hopefully someody has done it

Any help would be very very appreciated!

cheers,

frank grimes

 

[rise4peace]

SELECT * FROM [Retail @home$A11:H46] UNION ALL SELECT * FROM [Retail
@home$J12:Q46];

 

[Guest]

I am sorry, I am not able to answer your question,but I have another
question about axSpreedsheet. Could you help me?
How can i access the names which defined in axspreedsheet11.0?
for example:
System.Collections.IEnumerator myEnumerator =
axSpreadsheet1.Names.GetEnumerator();
Console.WriteLine("The Array contains the following values:");
int i = 0;
while ((myEnumerator.MoveNext()) && (myEnumerator.Current !=
null))
Console.WriteLine("[{0}] {1}", i++,
myEnumerator.Current);

but the result can not list the names just display "System._ComObject".
thank you!