Hello i don't have excel is it possiable to make a database out of Visual basic 6.0? or Microsfot works? becuase i noticed a Database option . . .is it possable or should i just get Excel and not waste my time trying to learn anything else if there is an easy and more popular way?
------------------
Cory Sanchez
Young Student
ICQ#: 18640149
As far as I know, Excel is simply a spreadsheet program, I've never heard of anyone making a database in Excel. However, Microsoft Access, is a very common database program. I think if you're planning on doing much with databases, you should buy a program that is designed to create and manage databases. There might be a way to make a database just out of Visual Basic, but it would be difficult, time-consuming, and VERY tedious. Then once you have your Access database up and running, it is not hard to create a custom front end application to control your database in VB.
------------------
Ryan
[email protected]
ICQ# 47799046
This is how i make a database with VB5.
Dim dbsNaam As String
Dim dbsNieuw As Database
dbsNaam = "C:\Temp\Newdb.mdb"
Set dbsNieuw = DBEngine.CreateDatabase(dbsNaam, dbLangDutch)
dbsNieuw.Execute "CREATE TABLE Historie " & " (Datum DATE, Video1 TEXT, Video2 TEXT, Video3 TEXT, Video4 TEXT, Video5 TEXT, Video6 TEXT, Video7 TEXT, Video8 TEXT);"
dbsNieuw.Execute "CREATE INDEX NewIndex ON Historie" & "(Datum);"
dbsNieuw.Close
Maybe it isn't good then i hope others will help you further.
Greeting,
Nico Berg
[This message has been edited by Nico Berg (edited 11-17-1999).]
[This message has been edited by Nico Berg (edited 11-17-1999).]
I have an example of how you can easily create a Database using code. I send it to you.
------------------
omarswan