-
Problems importing data into SQL 2005
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.
-
Possible to change data type to nvarchar?
-
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|