• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Create a Table in MS-Access Using VB Code.

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
• 2
• 3
• 4
• 5

(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