Ok, so here's the problem:
I have a database with tables made with Microsoft Access.
I know how to connect to this databse, and retrieve information in the tables, and update the information in the tables.
I was hoping someone could help me with the code for inserting new tables, and possibly modifying columns in existing tables in the database.
I am using the free vb2005
Table1 = New DataTable("studentCP414") Dim Row1 As DataRow Try Dim fName As DataColumn = New DataColumn("firstName") fName.DataType = System.Type.GetType("System.String") Table1.Columns.Add(fName) Row1 = Table1.NewRow() Row1.Item("fName") = "Reddy" Catch End Try
Is how I assume I'm suppose to make a table, but how do I insert this table into a database?