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