Thanks, RGR'us.

I put it in like:

   Dim CHIL0708A1 As Object

   'Specify the Query

    cmd.CommandText = "SELECT * FROM CHIL0708A1"

    cmd.CommandType = adCmdText

    Set cmd.ActiveConnection = ConnectionObject

    Set rs...

Hi RGR'us, Thanks for your help.

Your "Set cmd=New ADODB.Command" worked nicely.

I ran the program with "Set cmd=New ADODB.Command" placed before cmd.CommandText = "SELECT * FROM CHIL0708A1". I got a new...

Hi Martin, Thanks for your response.

The Access "Pivot Table" obtained from the original "Table" or resulted "Query" can be viewed only. If the Access "Pivot Table" is exported to MS Excel 2003, the...

Hi JackSteezo,  Thanks for your VBA code of Excel Automation.

I did what you instructed me to do: copied the code and ran it in a new Module of Access 2003.  The code was...

Hi JackSteezo,  Thanks for your response.

Please give me more direction for doing it in VBA via Excel Automation.

Thanks again,

Scott  Chang

Hi Richard,

It should be "NorthwindCS".  I just edited that old post to make a correction.

Thanks,

Scott  Chang

***************************************************

P. S.

I am thinking to use the "default" instance of this MSDE 2000 Release A to...

Hi Otto,  Thanks for your responses.

I tried very hard to do the "default" instance and the 2 "named" instances you told me and I got a mixed result: the "default"...

Hi Otto, Thanks for your respones.

I have an independent Windows XP Pro that is built on Microsoft NT 4 LAN System - it is local.

I copied the NorthwinCS.SQL and NorthwindCS.adp...

Hi Otto, Thanks for your respones.

I have an independent Windows XP Pro that is built on Microsoft NT 4 LAN System - it is local.

I copied the NorthwinCS.SQL and NorthwindCS.adp...

Hi SQLBill,  Thanks for your 2 responses.

1.  I put [NAB-WK-EN39197].nab.ds.usace.army.mil in and executed the program and I got the same error message.  More suggests?

2.  I will try to change my...

Hi SQLBill, Thanks for your help.

I found my "Computer_Name" as you instructed. I used it to change the "str1" code statement as

str1 = "Provider=SQLOLEDB;Data...

Hi Ray, Thanks for your response.

I do not understand your response completely.  I am not a computer expert and need more technical details of what you mean by "..you must...

Hi Remi, Thanks for your response.

I am new in this SQL Server thing. I do not know what you mean in the first two questions!!!???  Please be more specific in...

Hi all,

I want to add more information of the symptom in my SQL Server 2000/MSDE installation. Last night, in my Windows XP Pro - Dell 4100 PC, I clicked on Control Panel =>...

Hi Rudy, Thanks for your response.

I am a sole user of my 'upgraded" Windows XP Pro Dell-4100.  I have no ideas about whether I have an administrator account on the XP computer...