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 |
|
pharoah35
Yak Posting Veteran
81 Posts |
 Posted - 2009-11-19 : 08:08:47
|
| Good morningI certainly hope you can assist me and/or point me in the right direction. I'm running SQL 2000 with SP4, I have a standard .TXT filein which I import into a table. Once imported into the table, some of the fields contain the following strange chars ( Â Â Â Â ).So first I deleted the contents of the table, then re-imported the .txt file and the same strange chars appeared in the table. Then I dropped the table, re-created the table, then re-imported the .txt file into the table and the same strange chars appear in the table.I double checked the source .txt file and the strange chars do not exist in the source .txt file. Thus whats causing these strange chars to appear in my tablePLEASE HELP.... |
|
|
|
|
|
HELP, getting strange chars imported into table