Home Forums SQL Server 2012 SQL 2012 - General Importing Excel table into existing table RE: Importing Excel table into existing table

  • August 26, 2014 at 4:24 pm

    #1741151

    Perry Whittle (8/26/2014)

    cbernardes (8/25/2014)

    When I go through the wizard, it does not allow me to chance the Source Type for my Source Column.

    That's because they're set in excel, you'll need to tell the wizard the type of the target column

    Thanks your for your reply. As stated in my other reply before this, I found out to change my data types properly, the SSIS is the way to go.