how to import excel data into sql server using vb6?

[ghazal01978]

hi all
I need some help
how to import excel data into sql server using vb6?
I have a sub , and used that but for many fieldes had problem , although those fields had text format data , vb complier saya that , those fields are null!!!
and can not import!!