Anyone familier with SQLServer's DTS?
This is a discussion about Anyone familier with SQLServer's DTS? in the Windows Software category; 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.
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
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
Participate in our website and join the conversation
This subject has been archived. New comments and votes cannot be submitted.
