I have an Excel sheet accessed over an ADO connection which has daily data values for a few years. I need to extract a certain month range out (5-11/May to November for instance) for all the years, and I only need one column. Luckily, there is a seperate column which has the month value (numerical) for every entry.
I have tried writing an SQL query to do this, but so far am gettin syntax errors (I am using VB.NET in VS 2005)
strQuery = "(SELECT F2, F10 FROM [Paddock$] WHERE (F2>=5) AND (F2<=11))"
As you may or may not be able to tell I have had very little experience with SQL. I have used a couple of other statements almost identical to this (except lacking the WHERE part) in the same program and they are working fine (ie the connection is fine, sheet exists, columns exist and all can be read).
Any help would be appreciated
This post has been edited by scalt: 15 January 2008 - 07:03 PM