LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Probleme MESTRELLA29 Excel Discussion (Misc queries) 5 December 26th 07 09:12 PM
Probleme saving xls file with C# Folkien Excel Programming 3 August 10th 06 02:24 PM
Problème avec une boite de message! [email protected] Excel Programming 3 July 18th 06 10:27 PM
Last cell and first emty???!!! JohnDK[_8_] Excel Programming 5 November 9th 05 01:47 PM
Find emty cell in column and insert value Mikus Excel Programming 3 August 17th 05 01:47 PM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"