XLODBC - too many empty lines

[burton77]

Hi there...

I have this code that someone did for me, but there are only a few lines at the top half of the page, and the rest is all empty cells - even going onto the next page.

Can somebody tell me what to Edit so that the (about 10) empty rows are not added on the results sheet.

Here is the code:

XLODBC
1
DSN=WinDebi;DBQ=C:\WoffPlus\DB\WDP00000.mdb;DriverId=281;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;SystemDB=C:\WoffPlus\DB\Wrigpsd.mdw;
SELECT DISTINCT DEBI0000.RECHNNR, DEBI0000.TEXT, DEBI0000.RBETRAGFW, DEBI0000.D_AUSGANG, DEBI0000.BEMERK, DEBI0000.P_M, ST__0000.STCODE  FROM `C:\WoffPlus\DB\WDP00000`.DEBI0000 DEBI0000, `C:\WoffPlus\DB\WDP00000`.ST__0000 ST__0000  WHERE DEBI0000.RECHNNR = ST__0000.RECHNNR AND ((DEBI0000.D_AUSGANG>{ts '2002-01-01 00:00:00'} And DEBI0000.D_AUSGANG<{ts '2003-12-31 00:00:00'}) AND (ST__0000.STCODE=4) AND (DEBI0000.ART='Z'))  ORDER BY DEBI0000.RECHNNR


RECHNNR	TEXT	RBETRAGFW	D_AUSGANG	BEMERK	P_M	STCODE

Is there maybe a syntax in there that is making the empty rows, or what is it that is doing that? Any explanation?