I am new to Vb and Databases and i am Wondering how to make a DB without excel

[struntz]

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

[Gimpster]

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

[Nico Berg]

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).]

[omarswan]

I have an example of how you can easily create a Database using code. I send it to you.

------------------
omarswan