We can do it thro' active x scripts

--First You have to open the text file and change the filed on the text file.

--Transfer the data from changed text file to...

You can do it in many ways.

Just import the data to the table and exec the Update stmt to chage the employee number on the table.If it is a Pk...

First try to upload the data to the SQL table.Try this, create a DTS which creates the new table and extract the data from excel to SQL table and validate...

Itz better run the SQL server services on the domain/admin a/c (this a/c).

Chk the pkg owner info,If it has the different than the domain/admin,Then chk the rights for the pkg...

I havn't installed the MSDE on that developer's m/c.I just installed the client tools(Enterprise mgr,Query Analyzer and books online ).Do I need to apply the SP for this utilities?

Hi Tim,

I try to execute the code which you have given here.I have the following questions abt this script.

This is the fn code to download the file.

HRESULT URLDownloadToFile(

LPUNKNOWN...

Phill Thanks for the help and I have no problem with the file transformation.

I need to CONNECT the FTP Server first and second, Down load the file to the network...

quote:

---

Yes as the service actually has the password typed into it. You will need to change the password and then restart the...