how can i do this?

first i have to create a excel object right?

and then what?

importing.. sorry

Hi,

A little more details ´what are you doing. Importing from etc.

I´m trying to import an excel sheet with "n" rows and 2 columns into variables inside vb 6...

i´m trying to do a sort of select ( sql style) , that´s why i need to import the data from the excel sheet...

Hi

You must first set reference to Microsoft Excel library

Here is an example how to read Excel table to an array

Sub Load_Data()
Dim xlApp As Excel.Application
Dim Table
Set xlApp = New Excel.Application
xlApp.Workbooks.Open FileName:="File.xls"
'*** Takes whole table to an array
Table = xlApp.ActiveSheet.Range("A1").CurrentRegion
xlApp.Quit
Set xlApp = Nothing
End Sub


-vemaju

but that code sample only works for one collumn right?

for example:


i have the following excel table for e.g.:

user Id | number
----------------
1 | 0
1 | 2
2 | 1


and i want to return the data referent to the user with id=1

for eg:

select *
from table
where userId =1

How can I transcribe this into Vb???

But then i want to set the results of this select into some variables...

What are you doing with the data once it's in VB6?

hi,

without opening the workbook with the worksheet u need data from, try this:

path = [path where the file is located] (with \ at the end)
filename= [workbook where data has to be collected]
sheetname = [sheet from worbook with data]
'
string = "'" & path & "[" & filename & "]" & sheetname & "'!" & "r" & i & "c" & j
(i represents the row, j represents the column)
value = ExecuteExcel4Macro(string)

put this piece of code in a loop and your done