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)