Extracting data from an EXCEL file

[vdraceil]

Hi friends..i hav a small problem.Can anyone help to extract data from an MSExcel file and make a MSAccess file out of it..I'll do the rest if i can extract data from excel from VB6.0 (which i'm using)

[kadghar]

...I'll do the rest if i can extract data from excel from VB6.0 (which i'm using)

well, then create an object with an excel application and use it as with VBA. e.g.

dim obj1 as object
dim arr1(10) as string
dim i as integer
set obj1 = createobject("excel.application")
obj1.workbooks.open "c:\book1.xls"
for i = 1 to 10
    arr1(i) = obj1.cells(i,1).value
next

HTH