well,

i have so far compiled the following sytax:-

INSERT INTO mdb-dbo.ca_owned_resource (resource_name)

SELECT SoftwareTitleName, (own_resource_uuid CAST(NEWID() AS BINARY(16))

FROM(SELECT APPLICATION.SoftwareTitleName

FROM Asset AS ASSET LEFT OUTER JOIN

...

Hi,

Ok... there are some changes to the initial query...

1. I have a SQL statement which lists me all those 2000 record set, so i do NOT need Excel sheet anymore.

2....

hi,

i have re edited my post for a more clear picture of what i am trying to do.. hope this suffice ?

regards

abhi