Carolyn,
I have not experienced this exact problem before, but any time I have issues importing data from one source to another, one of the first things I check is that the data type on the source and destination are the same. In this case nvarchar.
Also, how are you importing this data from Access to SQL Server? What tools are you using?
Jon