How Do DROP as table with ADO if table exists and Create field if dont exist's
ADO Code:
sqlstr = "DROP TABLE Employees"
error's if it doesnot Exist's
similarly
ADO Code:
' Create the Employees table. conn.Execute _ "CREATE TABLE Employees(" & _ "EmployeeId INTEGER NOT NULL," & _ "LastName VARCHAR(40) NOT NULL," & _ "FirstName VARCHAR(40) NOT NULL)"
error's if EmployeeID or else field's exist's
please help me out !!




Reply With Quote