ViolentGreen 0 Posted June 12, 2003 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 Share this post Link to post
