yes i tried to enclose them in single quotes but in VBA Editor it does not allow me to,....
the line turns red...

Code:
Sql = "ALTER TABLE" & 'tbl' & "ADD COLUMN" & 'col' & text(10)"
the error is with the single quotes