Retry the second one prepended with "SELECT * FROM "

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=P:\Statements\Activity20100422.xls','SELECT * FROM [Trade Date Detail$]')

-------------------------------------

---- YOUR CODE --------------------

-------------------------------------

DECLARE @MobID as varchar (7)

DECLARE @ServNum as char (9)

SELECT @MobID =(SELECT MOBID FROM inserted)

SELECT @ServNum = (SELECT ServiceNumber FROM inserted)

-------------------------------------

---- SUBSTITUTE WITH THIS CODE---

-------------------------------------

DECLARE @MobID as varchar (7)

DECLARE...

Yes your right. Cursors blow... but so do correlated subqueries....which is what set-minded folks do for fancy looping. While statements don't calc for each tuple. But I am always looking...

Ok so I answered how to hold onto all the rows in table "inserted" and "deleted". Don't need a cursor for that. But you do for other stuff.

It has...

This took me a while to do the first time but it works.

Too bad SQL doesn't do this for us. I am not into all the bitmatching and hexing...

Oops on SQL in post, its a little hacked.

At any rate I read your post again and thats really what I am doing too in this case.

In my...

Hey the smily faces aren't mine, but use a temp table and maybe a cursor for nice processing of each row. Also don't listen to any rheotoric about cusors...

Then you...

No expert here but I know where you can find one.

Check out http://www.sqldts.com/?246

This is a really useful site with tons of DTS expertise overflowing.

His example of looping uses a...

How about Dynamic Properties Task? I can show SQLSERVER example you can fit to call PL/SQL proc or something?

Add a "Dynamic Properties Task" to your DTS layout and put it in...

Your EXEC doesn't yet know about the parameter.

Try this.

SET @SQL = '

SELECT @RESULT= nombre

FROM OPENQUERY(linkedServer, ''

SELECT lastname + '''', '''' + name  AS name

FROM dbo.tblEmployees

WHERE user_id = '''''...

Docmd.TransferDatabase does not have timeout option and neither does your DSN you are using to see database.

Are you willing to recode the solution?  Quickist is to make DTS package...

Nicely done. Hats off to sticking with TSQL for the solution.

Good example with lots of step by step help.

IMHO while other languages have features, TSQL is server based...

Maybe the NOCOUNT like previous post needs to be ON

It wasn't in your example and it has tripped me up many times in ADP.

Wierd error messages that aren't really...