Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using As a Database
How do I make my Excel Workbook a databse? And how do I get it compatible
with Visual Basic 6.0? |
#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: How do I make my Excel Workbook a databse? - you can make an excel "database" in a worksheet by putting headings in row 1 for your fields, then typing each record as a row underneath the headings without leaving any fully blank rows or columns, you can not however, make an excel workbook a database. And how do I get it compatible with Visual Basic 6.0? - AFAIK it already is -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Donald" wrote in message ... How do I make my Excel Workbook a databse? And how do I get it compatible with Visual Basic 6.0? |
#3
|
|||
|
|||
"Donald" skrev i melding
... 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/inde...nvbadacwbdbado 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
Graphing Database Growth Rate | Charts and Charting in Excel | |||
Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
Need help with exel database | Excel Discussion (Misc queries) |