InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:32:03 GMT20http://www.sqlservercentral.com/Forums/Topic1283352-392-1.aspxtry using an open query[code="sql"]SELECT [Col1], [Col2], [Col3] INTO DestinationTable FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=C:\YourFolderLocation\yourFileName.xls;Extended Properties=Excel 8.0')...[WorkSheetName$]SELECT [Col1], [Col2], [Col3] INTO DestinationTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\YourFolderLocation\yourFileName.xls', [WorkSheetName$])SELECT [Col1], [Col2], [Col3] INTO DestinationTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\YourFolderLocation\yourFileName.xls', 'SELECT * FROM [WorkSheetName$]')[/code]Tue, 19 Feb 2013 16:51:16 GMTKevin.roberts25http://www.sqlservercentral.com/Forums/Topic1283352-392-1.aspxcouldnt you copy the excel schema into a table form and sync up the rows and columns that way?Tue, 19 Feb 2013 16:00:55 GMTraym85http://www.sqlservercentral.com/Forums/Topic1283352-392-1.aspxIf you need something in specific cell you could look at this. I was looking for something similar and found it very useful.http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70024/Tue, 19 Feb 2013 15:36:13 GMTYev-704641http://www.sqlservercentral.com/Forums/Topic1283352-392-1.aspxWHen adding Excel Source and under "Show Advanced Editor" and in Component Properties you could specify your own OpenRowset like Sheet1$A3:H3 where A3 is first column and H3 is last column to read data from.Tue, 19 Feb 2013 15:34:28 GMTYev-704641http://www.sqlservercentral.com/Forums/Topic1283352-392-1.aspxHello Everyone,Hope all is well.I was wondering if I can import data from an excel sheet only from specific cells to sql server 2008 r2. I can we can do this through sql import task but I want to know I can select data from specific cells only.Thanks for your help.Fri, 13 Apr 2012 12:35:34 GMTSapen