I've been telecommuting two days of each week with every other Friday off so it ends up being 1/2 time telecommuting. The experience has taught me quite a lot...

Farrell,

Thanks!  That seems to be working well.

Steve

Farrell,

I should have posted my cleanup code.  As you can see I've tried your recommendation previously and still get hosed text.

 UPDATE @Main SET

  PN=REPLACE(PN, CHAR(44), '')  -- comma

 FROM @Main

 UPDATE @Main...

Go into the table design using Enterprise Manager and set it.  Otherwise, create a new Access Project (with existing data) and use the Access front-end to do the same thing. ...

Most likely when you brought the data into SQL Server it was without the primary keys.  You MUST have a primary key in SQL Server to edit data.  It is...

BUT, if you don't use a cursor and use the INSERT and UPDATE commands it will process hundreds of times faster.  The T-SQL shown doesn't and processes extremely fast.

Why not create your own UPSERT T-SQL stored procedure for your data?  It's simply the combination of an update and insert in a single stored procedure.

CREATE PROCEDURE spUpsertWuc

AS

 INSERT INTO tblWUC...

It is not my intent to be in a mood, Michael, but merely to advise.  My comments were about Access and not Office interactivity.  You are correct about Office 2000...

Somewhat less than a million if you consider that Access 2003 projects could use SQL Server 2005 so security it handled by SQL Server; performance then would also be SQL...

Assuming you have an integer ID (Identity 1,1) use a MOD type operation.  If you don't have an ID IDENTITY(1,1) then create a temp table with one and insert your...

I always alias all tables in multitable queries.  It tends to make the query much clearer and cleaner.

update vv1 set vv1.mtht = vv2.mtht,

vv1.mthtsp = vv2. mthtsp,

vv1.mthtax = vv2.mthtax,

vv1.mttva...

You haven't mentioned whether you  have a key in the TOEROK table and that you have SELECT, UPDATE permissions on the table.

A parameterized query passes a value into the query.  The TSQL you have shown uses a variable embedded in the query; not really a parameterized query.  If you want to...

Yes, it is an Excel file.  I deleted it and recreated the Linked Server and modified permissions and am now able to select data from the server.

EXEC sp_addlinkedserver

Yes I can expand to the tables.  The provider string is 'Excel 8.0; IMEX=1' and the product name is 'Jet 4.0'.  We have been using this successfully for months before...