SQL Server: How to Avoid Data Loss During Migration From MS Excel

While importing data from excel sheet, keep in mind that, SQL Server export/import utility look into first row of your data in excel sheet to guess data types of different columns. Problem occurs when we want to import columns, which contains both numeric and character data.