Well, I do not have the disks to reinstall, so I think I will upgrade to 2005, but what you said made much sense - relating to other .dll anomalies I've...

Steve,

Thank you for your insight.

Ah I figured it out...I had the wrong parameter specified.

Thank you both for the very informative descriptions!

OK, here 'tis in its most economical form...(and it works!)

Function MakeTblSproc(FileTypeText As String)

On Error GoTo FreeWilly

    Dim MyCmd As ADODB.Command

    Dim rs As ADODB.Recordset

    Set MyCmd = New ADODB.Command

  ...

Carla, Thanks so much. I thought it was redundant to re-connect with an .adp file. Nevertheless, I got it to work with establishing connection, but I will tailor it to...

OK, This is killing me... I am still getting 'Connection cannot be used to perform this operation...' error. I'm not understanding how ADO  cannot make the logical conclusion that I'm using...

Very well...thanks again...I will persevere.

OK thanks for the code. I will deduce the necessary components. I'm new to SQL server and for that matter coding with ADO, so I wasn't sure if I needed...

Ohh sorry, here it is....the parameters are referenced in the WHERE clause

CREATE PROCEDURE dbo.spEVA_Export(@EndDate varchar(20), @Account1 varchar(20))

AS INSERT INTO dbo.tblEVA_Export

                      ([Account Number], Filler0, Filler01, [Record Sequence Num], [Security Name], Rate,...

OK here's the full sub...

Private Sub Command84_Click()

On Error GoTo Err_Command84_Click

    Dim cmd As ADODB.Command

    Dim rs As ADODB.Recordset

    Dim params As ADODB.Parameters

    Set cmd = New ADODB.Command

    With cmd

        ...

It's on a different PC. I'll remote in later this afternoon and get it to you.

THanks...