Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sql probleme on emty cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sql probleme on emty cell
This might seem too simple but why not actually open the .xls file in excel,
read the rows you want and then create the new one? "Ralf Meuser" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |