How do I "Insert" using a type member?

Hi,
I'm a newbie to VB and SQL.  I have VB6 and SQL7.  I'm trying to insert
Strings that are members of a type into SQL,  This is what i've tried with
no success.  How do you do this? and how would I do this using a stored
procedure?

'SQL = "Insert SoftwarePackage(Name,Path,Size,nFiles) " _
'   & "Values('" & sw.cName & "'," _
'   & sw.cPath & "," _
'   & sw.sSize & "," _
'   & sw.hFiles & ")"