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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Index server Performance issues
    ... file types in the catalog. ... The SQL query we issue for this is: ... decreases to 15 seconds for 10 concurrent queries. ... The MaxActiveQueryThreads entry is the maximum number of active threads to ...
    (microsoft.public.inetserver.indexserver)
  • RE: How to discard the error in SQL query
    ... PrintError will just print the error and go on its merry way ... How to discard the error in SQL query ... I am executing list of SQL queries from a file. ...
    (perl.dbi.users)
  • SQL parsing library
    ... take an SQL query (which may already contain some ... metrics on the frequency and average running time of queries in the ... and I want to treat all queries of the same general form as ...
    (comp.lang.java.databases)
  • Re: SQL parsing library
    ... > in mind is as follows: take an SQL query (which may already contain some ... > metrics on the frequency and average running time of queries in the ... and I want to treat all queries of the same general form as ...
    (comp.lang.java.databases)
  • Skipping queries to be exported
    ... and exports them to an Excel spreadsheet. ... queries where no results are returned to make the spreadsheets more ... Dim dbs As Database, qdf As QueryDef ...
    (microsoft.public.access.modulesdaovba)