Opening DB after check with excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need the database to look at an excel worksheet and check to see if todays
date is less than the date entered in a cell on worksheet named "check" in a
workbook named "Date.xls"


how do i do this?

thanks in advance
 
hi,
i need the database to look at an excel worksheet and check to see if todays
date is less than the date entered in a cell on worksheet named "check" in a
workbook named "Date.xls"
Click to expand...
Use a query:

SELECT *
FROM [Excel 8.0;Database=Path\Date.xls;Hdr=No].[Check$B2:B2]

Use [Check$] to read the entire sheet or use an appropriate range after
$FromCell:ToCell.
Set Hdr=Yes, if your Excel sheet contains column headers.


mfG
--> stefan <--
 
Back
Top