Thank you for the help. Let me try to work out how to...

Yes, I tried a DTS...

It appears that the problem is that you cannot use an "@" in a Create Table.

So somehow I need to be able to generate the GetDate() result and then...

Thank you,

I added into the SP the:

DECLARE

@ddlname varchar(100)

And also added:

set @ddlname = 'Create Table Table_' + getdate() + '

(dbid Int, id Text, login_name Text, rleasenumber Text, releasestate Text)'

And...

Cory Ellingson (4/24/2008)

---

this is untested but:

CREATE PROCEDURE spExecute_ADODB_SQL

@DDL VARCHAR(2000),

@DataSource VARCHAR(100),

@Worksheet VARCHAR(100)=NULL,

@ConnectionString VARCHAR(255)

= 'Provider=Microsoft.Jet.OLEDB.4.0;

Data Source=%DataSource;

Extended Properties=Excel 8.0'

AS

DECLARE

@objExcel INT,

...

@filename...