How do I make my Excel Workbook a databse? And how do I get it compatible with Visual Basic 6.0?
D Donald Apr 22, 2005 #1 How do I make my Excel Workbook a databse? And how do I get it compatible with Visual Basic 6.0?
J JulieD Apr 22, 2005 #2 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:
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:
H Harald Staff Apr 22, 2005 #3 Donald said: How do I make my Excel Workbook a databse? And how do I get it compatible with Visual Basic 6.0? Click to expand... 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
Donald said: How do I make my Excel Workbook a databse? And how do I get it compatible with Visual Basic 6.0? Click to expand... 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
