I need to give the ability to only somewhat technically minded people to
insert/ update into 1 SQL table. They have data that comes in frequently
from Excel files that needs to be imported and we want to make it so they
don't need IT. There's no way to install just DTS without installing
Enterprise Manager so thats out. Is there another tool?

--
SQL2K SP3

TIA, ChrisR

Hi

I would write yourself a sceduled dts job that takes the file from a
specific location, processes it, and then archives it to a different
location. Therefore the only thing the user will have to do is move the file
into the location where it will be processed. See
http://www.sqldts.com/default.aspx?246 If you are wanting to cut out the
middle man totally you could use SQLMail and xp_readmail to recieve the
file.

John


"ChrisR" <bla (AT) noemail (DOT) com> wrote

The problem though is that the file format of the file isn't constant. The
people that send them to us rename columns, dont have the data the way they
really want it, etc. Thats why I need a GUI that isn't DTS.



"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

Chris,

There are numerous third-party data transformation products available...
Here's one that I have not used before but that looks pretty interesting
based on the website:

http://www.idera.com/Products/DTx/Default.aspx

--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--


"ChrisR" <bla (AT) noemail (DOT) com> wrote

How about a simple .net app?
If you use a datagrid then the users should be able to copy the contents of
the spreadsheet into the grid, click a button to import.

I have a system where the users put the data into a spreadsheet then a macro
does the copy to a table and am planning to replace it with the above. Should
only take a few hours to write so sometime middle of next year I guess .


"ChrisR" wrote: