How can fix the problem so it will populate all the data

I am a web programmer I am just doing this on the back end.

I wrote stored procedures and they worked, but the company does not want to use SP....

I broke the query down but still unable to update the table

Function Main()

Dim cn '* As New ADODB Connection

Dim strConn

dim rs

Dim strSQL

Set cn= CreateObject("ADODB.Connection")

Set rs = CreateObject("ADODB.RecordSet")

' Connection to...

it does not give me any error it just does not update the table

Because the table contains other data

I am trying to update the table Since I already copied data the Id's on thedestination tables has been changed

fffff

Thanks it works

Yes I do have data that I need to access on the different database. That where I am getting the faculty status

By using DTS package

OK. I need to perform update. If the status change (from Full time to part time ) I need to update intCategoryId in both tables to 689

Here is the table tblItem defenition:3

intIDint40

intUIDuniqueidentifier160

intWebIDint40

intDataTypeint41

intNavIDint41

intSubIDint41

intTabIDint41

blnFeaturedbit10

blnDeletedbit10

blnApprovedbit10

intApproveUserIDint41

dtExpiredatetime81

intOrderint41

intWebBackupIDint41

blnStagingNewbit10

blnStagingChangebit10

intCategoryIDint41

blnNeedsTranslationbit10

intLastLevelint40

and tblFacultyListing Definition:

3intIDint40

0intUIDuniqueidentifier160

0intFacIDint41

0txtTitlenvarchar5001

0intCategoryIDint41

0txtAbstractntext161

0blnNotificationbit11

0blnPrivatebit11

0txtDescriptionntext161

0intItemIDint41

0intResourceIDint41

0blnLivebit11

0dtAddeddatetime81

0dtStartdatetime81

0dtEnddatetime81

0txtMetaKeywordsntext161

0txtMetaDescriptionntext161

0intMetaIDint41

0intImageIDint41

The sample data is for tblFacultyListing

8732{2501F879-FD04-45F7-8BCE-E46BE9118C0C}486Agresti, William6880102310

8733{DF9DD2A5-01C5-4AA1-9486-B09562B0A3F7}406Anikeeff, Michael6880102321

8734{05254D4E-5019-4F61-A47D-AACBD23BF730}1115Baker Sr., John6880102331

8735{5BD132D0-856D-485C-B50E-1D9DFB04AAD3}1901Brunetti, Celso6880102341

8736{CAE6ACDB-B1D6-4B81-8D95-CF469CBD8B8F}1158Calvin, James6880102351

8737{726A46E7-22A9-447F-8AE3-58AAFE1BF232}1327Cheong, Kwang Soo6880102361

8738{012C1F40-4287-44B3-BB29-5306A26E13A4}1155Crain, Thomas6880Thomas Crain, AM, holds the position of Director,...

Thanks

But I am using the right approach because my task will has to be scheduled every day

Hi I have problem here. I am trying to copy the data from 1 table to another but only want to copy the unique records. I wrote dts package that...