Microsoft Office Tutorials and References
In Depth Information
Step-by-Step
‘Establish the command that adds a field for a middle name.
dbCommand.CommandText = _
“ALTER TABLE tblEmployees Add Column MiddleName text)”
‘Execute the command to create the new field.
dbCommand.Execute , , adCmdText
‘Release Object variable memory.
Set dbCommand = Nothing
Set dbConnection = Nothing
End Sub
To view the video that accompanies this lesson, please select Lesson 29, available
at the following website: www.wrox.com/go/excelvba .
Search JabSto ::




Custom Search