import script to SQL server 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

import script to SQL server 2000

Hi, i have an excel spreadsheet that contains new salary information and new salary grades etc per employee……
this information needs to be reimported into the db with the new info.
this info goes into the salhistory table (which is an employees salary history),
what is the best way to do this,
is there a generic script that i can alter and execute
and what about the triggers for the tables
I suggest to use Advanced Search in this Forum, write DTS and you will find severas articles. HTH Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell