Anyone familier with SQLServer's DTS?

[ViolentGreen 0]

I have an excel workbook with multiple sheets. I need to import each of these sheets into a single table in SQL Server. I can get the BULK COPY SQL command to work if I save as a csv and do some tweaking to this 20 MB excel file.

 

Is there a way to pull the data directly from the xls, specifying the sheet? Also is the bcp command line do the same thing as the BULK COPY SQL command?

 

THanks