I am trying create a table in SQL using only 5 columns of data from a large spreadsheet. I am using the import wizard in SQL and attempting to write a query to only pull in those 5 columns. I keep getting an error related to file type conversions (see
below) for each column I'm trying to bring in. Any ideas or suggestions? I tried formatting my excel sheet to be 'text' and to be 'general' but it didn't help. I tried VARCHAR and TEXT as my destination types without success. Thanks!!
Source Column Source Type Destination Column Destination Type
DE_H 12 DE_H
View Complete Post