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

Hot Topic

Multiple variables on a Script transformation
copy changed data only
Web Service Listener
sqlserver does not connect
How to leverage custom security with ReportViewer and SSRS Web Service
RDA SQL MOBILE ERROR 28037 HResult = -2147012867
Insert / Update Trigger based on a column's value
Automated export of report?
How can i generate a cube of XML Data
Reports using Dynamic Columns

SQL Server

Send parameter from form to RS report
How to run an exe in the SSIS scripting task
Select date year below 1950 not valid?
Avoiding deadlock
Upgrading Replication - Effects ?
CurrentMember failed with (Multiple Items) in the 'filter fields'
difference of sqlserver management studio with query analyzer?
ODBC connect styring does not work
nvarchar(max) to Excel Destination error
Can't create stored procedure with access 2003 when connected to SQL 2005

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

Answer this question

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

  • parthiss

    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

  • TRID

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

  • soud

    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
    ---
  • How to use SQL Svr 2005 Express in Excel 2003 VBA code?
Answer this question