dcsimg
Results 1 to 3 of 3

Thread: Problems importing data into SQL 2005

  1. #1
    Join Date
    Jun 2007
    Posts
    15

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Possible to change data type to nvarchar?

  3. #3
    Join Date
    Dec 2008
    Posts
    1
    do with bcp utility

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
  •