thanks for the answers.

The select from Microsoft Query Editor SQL contains:
SELECT auslastung_0.zeit, auslastung_0.usr, auslastung_0.sys, auslastung_
0.wio, auslastung_0.idle
FROM auswertung.auslastung auslastung_0
WHERE auslastung_0.zeit like ' & Format$(Sheets("Tabelle1").Range
("C7"),"dd.mm.YYYY" & ';

C7 contains:
04.11.2003

DB contains for example:
04.11.2003 14:10

didn't work. There still must be an error?

thx mike

"Patrick Molloy" wrote in news:077a01c3a76d
:

sql="select * from database where date='" & sDate & "';"