Problem with importing/exporting variables with VB 6.0

Basically I've been trying to homegrow an old school game much like the old Wizardry games. I've come to a point where I want to pull up a spreadsheet from excel (can use MS access if need be) that contains 10-12 options and within those 10-12 options are 8 corresponding variables I need. (ie. variable 1 contains 8 variables that I need called up).

I've been looking through the libraries all over the net and seem to find something only to find out that it's the tip of the iceberg I needed. I've got 3 books (supposedly) all about Visual Basic 6.0 and programming in it...but seem not to have anything to do with what I'm asking about.

Any link or light into the situation would be greatly appreciated.

Blake

[742 byte] By [Akuma] at [2008-1-24]