InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 10:10:49 GMT20http://www.sqlservercentral.com/Forums/Topic1032839-392-1.aspxYup, easy solution is just Select destination database; right click go to Tasks -> Import Data. A wizard will show up to import and that give option to import from Excel. Select Microsoft Excel in DataSource.Select Excel file you need to import. Just follow the wizard steps. If you have long text in any column of Excel file; better to map the Source Column from Excel and Destination in DB table. Change the type properly that can parse Excel column's value else it will throw error.Enjoy!Regards,HimanshuFri, 10 Dec 2010 00:34:35 GMThimanshumarwahahttp://www.sqlservercentral.com/Forums/Topic1032839-392-1.aspxRight click on the Database. Select Tasks-> Import dataThe wizard will take U step by step.Select excel as Datasource.Fri, 10 Dec 2010 00:19:44 GMTPulivarthi Sasidharhttp://www.sqlservercentral.com/Forums/Topic1032839-392-1.aspx----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------IMPORT FROM EXCEL TO TABLE----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Select * into XLSheet1 from OPENROWSET ('Microsoft.jet.OLEDB.4.0','Excel 8.0;database=C:\Latest.xls;','Select * from [Report$]') ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------EXPORT FROM TABLE TO EXCEL----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------INSERT INTO OPENROWSET ('Microsoft.jet.OLEDB.4.0','Excel 8.0;database=C:\Latest.xls;','Select * from [Report$]') select top 10 * from DataReportFri, 10 Dec 2010 00:10:33 GMTSandeep Moturihttp://www.sqlservercentral.com/Forums/Topic1032839-392-1.aspxplz..........help any one .....how to import data from excel file to sql server databaseThu, 09 Dec 2010 22:54:51 GMTgupta.sreekanth