What is the best way to change data in a field for a list of accounts on an excel spreadsheet?  I have the slx account id for each line.     If I understand correctlyI should not do it with a SQL update, but through SLX. 

SLX 7.0.1

you've lost me on this Tom....

 are you able to read the excel spreadsheet through a vbscript that you have written?

Are you able to come up with the values desired from the excel spreadsheet in a vbscript code?

you do SQL updates through SLX.....either a SQL statement, command object, or ADO recordset update.....

Please post your code here and we can quickly write an ADO Connection, Recordset object, populate the fields to be updated....update the ADO recordset through SLX, close the ADO object, loop through the spreadsheet, etc.

Sorry to be vague.  I don't really have a lot of experience in this area.  Basically I have a list of accounts in an excel spreadsheet with data for accountid, account name, and account status.  I Need to update the matching record in SalesLogix with the new status.  Where do I begin if I want to learn how to do this?

I have done this type of thing before directly on a SQL databse through the Enterprise Manager. In that instance I created a temporary table from the spreadsheet and did a table to table update. 

Look in the "asge saleslogix lan developers reference" under "COM"

Sub ExcelButtonClick(Sender)

Dim objSLXApp

Dim objSLXBasicFunctions

set objSLXApp = CreateObject("SalesLogix.SlxApplication")

set objSLXBasicFunctions = objSLXApp.BasicFunctions

msgbox objSLXBasicFunctions.CurrentUserID

set objSLXBasicFunctions = nothing

set objSLXApp = nothing

End Sub

You can bring an EXCEL spreadsheet into a SQL Server table as well.....either through DTS or SSIS....Import\Export.....

then run your table joined to table update statement....just like you did before.

Did you need to Synch the data to remotes???

OR you can write a vbScript....

Scribe or Inaport or Starfish ETL can do this as well....

Depending on the number or records you are updating, I have a not so elegant solution. You can use excel to build individual update statements then cut and past them into a text document and use “Execute SQl” to run them all. This will be sent to remotes/disconnected clients. I have done this with a couple thousand updated before and it was effective. You just need to put a “;” at the end of each statements. If this is confusing I can through together a Google spreadsheet to show you what I’m talking about.

yea, I do that all of the time to even build code for VB Scripts.....or SQL to build SQL statements....