How to use SQL Svr 2005 Express in Excel 2003 VBA code?

Hello,

how can I use SQL Svr 2005 Express as database engine in background through VBA code in Excel 2003?

I want to CREATE and DELETE tables and SELECT, INSERT and UPDATE data. Is it possible to use ADO or other database objects to get in contact with SQL Svr 2005 Express?

Thanks a lot.

Christian

Yes, ADO is still supported... but... ADO 2.0 will take care of the new sophisticated features of SQL Server 2005 where ADO 1 doesn′t have a clue of, but at the end, ADO is still supported.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

This means VBA only supports ADO 1.0 and not ADO 2.0?

Do you have a code snippet for creating a connection, creating a table and selecting data from sql server express?

Thanks a lot.

Christian

|||Sorry, I was meaning ADO.NET 2.X not the old ADO.