Problem in Java/Excel JDBC:ODBC in querying date range. Urgent help required

[qaisar]

dera freind

here i am trying to read excel file using java code,i am able to establish connectivty,i want to get all rows between two particular date of particular column.. its compiling fine while running its showing data mismatch

import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
public class ExcelReader
{
public static void main( String [] args )
{
Connection c = null;
Statement stmnt = null;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection( "jdbc:odbc:qa-list", "", "" );
}
catch(Exception e)
{

System.err.println( e );
}
System.out.println("Connection Established");

try
{
stmnt = c.createStatement();
String query = "select * from [ftpqrm$] where [rcv end day] between '12/1/2005' and '12/8/2005'";
ResultSet rs = stmnt.executeQuery( query );
System.out.println( "Found the following URLs for March 2000:" );
while( rs.next() )
{
System.out.println( rs.getString( "Description" ) );
}
}
catch( Exception e )
{
System.err.println( e );
}
finally
{
try
{
stmnt.close();
c.close();
}
catch( Exception e )
{
System.err.println( e );
}
}
}
}

help required urgently

i am getting following error

java.sql.SQLException: [Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.

[sk_kireeti]

Qaisar,

If you are getting data type mismatch, try using to_date function for date comparisions. Now I belive it is string and in excel it is date field...

I am not sure if it will resolve or not. Its just a wild guess on the situation.

Thanks,
Krishna