VBA for Excel & Access
The Knowledge shop........
Pages
Home
Excel Tips
Friday, May 22, 2009
Add column to access table using SQL in VBA
Sub Addcolumns_Table()
Dim strsql As String
strsql = "ALTER TABLE [tablename] ADD COLUMN Column_name varChar(25);"
CurrentDb.Execute strsql
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment