Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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,PES O,SALIDA From [EXPEDICIONES$] Where DEST='ROU' and SALIDA='' ORDER BY LLEGADA",cnn,3,3,&H0001 Thanks in advance for your help Best regards Ralf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Probleme | Excel Discussion (Misc queries) | |||
Probleme saving xls file with C# | Excel Programming | |||
Problème avec une boite de message! | Excel Programming | |||
Last cell and first emty???!!! | Excel Programming | |||
Find emty cell in column and insert value | Excel Programming |