I'm trying to import data into my SQL Server 2005 database but I'm having a problem. No matter how i format the data, I keep getting an error that says it cannot convert unicode to non unicode.

I have tried going from Excel to SQL Server and from Access to SQL Server, I've tried saving the Excel file as a text file as well.

I realize the problem, my incoming data types are all text formats, and it can't convert them to varchar() or anything else it seems.

I'm still trying to find a solution but any help would be great.