I believe, it is now that companies should actually increase their IT budget. Technology allows to do the same job, more effienciently than it was before. Money is tough, and...

Thank you. This is SQL 2k. Can I still use it?

I think, I got it. As soon as I posted my question, I thought of OPENDATASOURCE. 

Here is the syntax if someone else requires it. 

SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=ServerName;User...

Here is a thought you could probably use.

If you table ID does not change (you dont drop and create it everytime but just alter) to create new columns then

You...

You may also use the MS-Query option from within Excel to pull the data and then manipulate as you want.

Convert(Char(10),GetDate(),103)

You can replace the GetDate() function by any datetime fieldname.

In that case, how would I go about doing that? I have not done anything like that before.

Thank you.

Thank you.

This is exactly what I was looking for. A list of files needed to run the DTS from a wrkstation without installing the whole client.

I use the DTS to format a file. The user need not know how the formatting is done - or rather, I want to make it as simple as possible for...

Thank you Michael for you input.

Seems like nobody has a straight solution for this.