R
Ralf Meuser
Hi there
I'm trying to create a small script reading a Excel sheet and creating a new
sheet.
But I want to get only rows without a date.
I tryed something like this: (SALIDA is my date)
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\uti\Mag1.xls;
Extended Properties=""Excel 8.0;HDR=Yes;"";"
rs.Open "SELECT LLEGADA,EXP,EXPEDITOR,DEST,DESTINATARIO,PALETS,PESO,SALIDA
From [EXPEDICIONES$] Where DEST='ROU' and SALIDA='' ORDER BY
LLEGADA",cnn,3,3,&H0001
Thanks in advance for your help
Best regards
Ralf
I'm trying to create a small script reading a Excel sheet and creating a new
sheet.
But I want to get only rows without a date.
I tryed something like this: (SALIDA is my date)
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\uti\Mag1.xls;
Extended Properties=""Excel 8.0;HDR=Yes;"";"
rs.Open "SELECT LLEGADA,EXP,EXPEDITOR,DEST,DESTINATARIO,PALETS,PESO,SALIDA
From [EXPEDICIONES$] Where DEST='ROU' and SALIDA='' ORDER BY
LLEGADA",cnn,3,3,&H0001
Thanks in advance for your help
Best regards
Ralf