Placing data from XLsheet into data table using sql server 2000

There are a number of ways to do this

• DTS package
• Import wizard from Enterprise Manager (right click on the database node, if I recall)

You can use eg. the Data Transformation Services or eg. OPENROWSET command.

You can take a look on MSDN: How to import data from Excel to SQL Server

If you are going through enterprise manager, right-click the database you want to import the data to and then scroll to All tasks -> Import data. Follow the instructions in the dialog box suppling the correct information. Make sure you have you Excel sheet closed though otherwise DTS will not be able to read it (That caught me out for a long time, long ago :D)