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