Using As a Database

[Guest]

How do I make my Excel Workbook a databse? And how do I get it compatible
with Visual Basic 6.0?

 

[JulieD]

Hi

if you'ld like to tell us what you're trying to achieve here we might be
able to come up with a useful answer because at the moment my answers to
your two questions would be:

 

[Harald Staff]

How do I make my Excel Workbook a databse? And how do I get it compatible
with Visual Basic 6.0?

See
http://erlandsendata.no/english/index.php?d=envbadacwbdbado
on the ADO approach.

But don't do it. Spreadsheets are not made for this. They are too small and
they are not relational. Use an Access mdb file instead.

HTH. best wishes Harald