Home Forums SQL Server 2008 T-SQL (SS2K8) import data from excel file to sql server database RE: import data from excel file to sql server database

  • Yup, 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,

    Himanshu