I am trying to import excel data into a sql table useing ADO in VB.
Everything works fine but, there are two fields in the excel file that come as date and currency. My table in sql has datetime and money data type for these fields. When try to append the data

by this method
rsSql.Fields(0)=rsExcel.Fields(0)
'
'
'
'
'
rsSql.Fields(10)=rsExcel.Fields(10)


all of the fields are updated but these two fields the date and currency are not updated can some one help me out with this?