hi all

I wish to write small program in vb6 which allow user to upload any excel file to oracle database.

using


Dim Cn as ADODB.Connection
Dim Conn as String
Dim vtblNametxt as String

vtblNametxt= tblNametxt.txt
Cn.Execute(“create table ‘ ” + vtblNametxt + ” ’ (id varchar2(3), pname varchar2(20), qtyp number(4))”)


first row of excel sheet contains the name of the field.

my quetion is how to get and set the attributes of fields from excel like type and length

please help