Hello Experts Exchange
I have a Excel spreadsheet (Please see attached) that I'm trying to import into SQL Server but I'm having a nightmare trying to do it, everything I have tried has failed.
I have followed the instructions on this web page but it did not work.
http://www.mssqltips.com/sqlservertip/1393/import-excel-unicode-data-with-sql-server-integration-services/
Several of the columns come back with the error of;
Column "Tool Code" cannot convert between Unicode and non-Unicode string data types.
Can anyone help me to create a SSIS package that will import the data into SQL Please?
Regards
SQLSearcher
MOULD-DIE-CHARTS-14-15.xls
Have a look at the following article for the steps involved and what to keep in mind: Importing Excel Data Using Integration Services