Re: Using Excel data in a VB6 database

Henk van Winkoop wrote:
My VB6 application needs customer data like
name/address/place_of_birth etc.

This customer data is available in Excel sheets.

I think the easiest way is to use some database which is
controlled by VB6. But thats all I know.

I recall hearing somewhere that you can actually use an
ODBC driver to access an Excel document. Of course, that's
a gross hack, but it is Microsoft software, so...

Anyway, if you can access ODBC databases from VB6, I guess
you could do it that way.

Of course, a better solution might be to not store the
data in an Excel spread*** in the first place, if it
needs to be accessed programmatically.

- Logan
.