Deleting a SQL server table

[azizrasul]

Does anyone have any VBA code that deletes a SQL server table?

 

[Kyle123]

The sql is simply drop tablename

Or are you asking how to execute sql against a database using Ado?

 

[azizrasul]

Would you not have to point to the ODBC connection in some way?

 

[Kyle123]

Yes, with ADO. Do you know how to connect to a database using ADO?

 

[azizrasul]

I am a fan of DAO. Don't have much knowledge of ADO I'm afraid.

 

[Kyle123]

There's a tutorial here:https://analysistabs.com/excel-vba/ado-sql-macros-connecting-database/

 

[azizrasul]

Many thanks, I'll look into that.