Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nebrown1
Starting Member
1 Post |
 Posted - 2003-06-13 : 10:35:34
|
| I have a sheet in an Excel workbook that I would like to import to a table in SQL Server. Three of my Excel columns are cells filled with text. Some of the cells have hard carriage returns in them, which show up in Excel as little rectangles. When I import them in SQL Server, they remain little rectangles and are not converted into what they really are: Chr(13) carriage returns.PS. I know they really are Chr(13) because I examined them in VBA and sure enough, they are real carriage returns.How to solve this? |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-06-13 : 14:28:20
|
| they LOOK like little squares in SQL Server, but what is actually being stored? Because some of the development tools for SQL Server (i.e., enterprise manager) will ALSO display a square instead of a CR.(by the way -- what about your linefeeds?)anyway, use some SQL to look into your imported data and return the ASCII value of the little square to see if it is coming over ok.- Jeff |
 |
|
|
|
|
|
Excel to SQL Server: carriage return problems...