SQL code that references excel date cell

• mallybee

  Mr or Mrs. 500

  Points: 584

  More actions

  April 24, 2012 at 4:03 am

  #254634

  Hi

  I have the following SQL WHERE statement in my SQL code which is in a OLE DB query in a 2010 excel file.

  where convert(varchar(10),datestarted,111) between '2012/04/16' and '2012/04/22'.

  Is there a way to reference date cells that are in the same file e.g.

  where convert(varchar(10),casestarted,111) between '$J$2' and $K$2'

  Thank you in advance for any help.

  Mally

• seth delconte

  SSCertifiable

  Points: 6388

  More actions

  April 24, 2012 at 8:57 am

  #1478254

  I don't think this is exactly what you're looking for, but it might point you in the right direction:

  http://stackoverflow.com/questions/1285686/excel-use-a-cell-value-as-a-parameter-for-a-sql-query

  _________________________________
  seth delconte
  http://sqlkeys.com

• mallybee

  Mr or Mrs. 500

  Points: 584

  More actions

  April 24, 2012 at 10:07 am

  #1478342

  Hi Seth

  Thanks for your reply.

  I'll try this tomorrow when i get back to work.

  Kind regards

  Mally