DTS from Excel with empty cell

Tech-Archive recommends: Fix windows errors by optimizing your registry

oriki9999
Date: 12/15/04 

Date: Wed, 15 Dec 2004 00:04:38 -0800

I have currently trying to import an excel spread*** with named cells
to SQL thr DTS..

My problem is that how to I skip those cell that are empty in the
spread*** using DTS activeX?

This is what I tried? (I have tried checking for isNull)

Function Main()
    'Check for not Null
    If trim(DTSSource("Field A"))=NULL Then
        Main = DTSTransformStat_SkipRow
    Else
        DTSDestination("FIELD_A") = DTSSource("Field A")
    end if
        Main = DTSTransformStat_OK

End Function

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Quantcast