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.

[CODE=vb]dim obj1 as object
dim arr1(10) as string
dim i as integer
set obj1 = createobject("e xcel.applicatio n")
obj1.workbooks. open "c:\book1.x ls"
for i = 1 to 10
arr1(i) = obj1.cells(i,1) .value
next[/CODE]

HTH