Novicejatt, again, this is a 2000 forum, and it seems like maybe you have 2008? Anyhow, as far as the one time uploads are concerned, I personally find OPENROWSET the easiest method for the Excel files, but that is just me. You can find out all about in BOL.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.