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 |
|
pgmr1998
Yak Posting Veteran
66 Posts |
 Posted - 2007-12-05 : 17:36:47
|
| I am uploading data from a server to my harddrive. I am uploading the data as ASCII text. Many of the fields look good, but there is one field that has the hex equivalence of the data, for example, blanks are displaying as 40 and 'T' shows up as E3. What function can be applied to this field so that I get regular characters to display? Thanks for your help... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-05 : 17:37:47
|
| How is the upload being performed?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
pgmr1998
Yak Posting Veteran
66 Posts |
Posted - 2007-12-05 : 17:51:19
|
| Using an ODBC connection and Client Access. |
|
|
|
|
|
|
ASCII text data conversion