I have a FIle from which i DTS to a Database Table...
one of the field in my Table should get the first 7 letters OF file which is my source.

Filename= ABCD111_dhf2324.xls(Spread sheet)

i need Field in my table DealType= Left(Filename) i.e. 'ABCD111'

can any one help me using it by FSO or ActiveX scripts