I am trying to import from an excel spreadsheet into a sql server table. However, It fails because of one of the columns in the excel spreadsheet is a value that needs to be converted to a uniqueidentifier
. The values in the spreadsheet look like this
Error 0xc02020c5: Data Flow Task 1: Data conversion failed while converting column "Vehicle_ID" (15) to column ""Vehicle_ID" (75). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)
How do I get around that using the sql server import and export tool. See attachment where it shows you an option to modify the query to do data transfer.