Create a Table in MS-Access Using VB Code.
Create a Table in MS-Access Using VB Code.
API Declarations
'Microsoft ActiveX Data Objects 2.1 Library
'Microsoft ActiveX Data Objects RecordSet 2.1 Library
'Declare these Variables
Dim Com as New ADODB.Command
Dim Con as New ADODB.Connection
Rate Create a Table in MS-Access Using VB Code.
(1(1 Vote))
Con.Provider="Microsoft.Jet.OLEDB.3.51"
'specify the Database here
Con.Open "c:\phil\stud.mdb"
Com.ActiveConnection=Con
'Code
Com.Commandtext="Create table stud(sno number(4));"
com.Execute
'Table is Created
Create a Table in MS-Access Using VB Code. Comments
No comments yet — be the first to post one!
Post a Comment