Excel column not importing as Varchar/char RRS feed

  • Question

  • Hi,

    When i use Select .......... from excel file into a SQL Server table, all charaters which start from 0 in excel columns converted as INT in SQL Table. I would like to import all column of excel file as varchar/char from excel file to sql table without using SSIS.

    Please help

    Virendra Yaduvanshi http://wikidba.wordpress.com/

    Monday, June 24, 2013 10:59 AM