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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-06-07 : 10:24:07
|
| Hi i've a txt file which i want to import into a excel file or a access db table, via DTS SQL 2000, the problem is, the extract i get has only double quotes example "text" "text" and no coma between them just a space. can any one help ? |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-06-07 : 10:34:14
|
| You can use replace function to replace "text" to text so you may insert on text. select replace("text",'"','').ThanksSanjeev Shrestha12/17/1963 |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-06-07 : 10:42:40
|
| I can't run the select replace as my data is in a txt file, or maybe i can ? can you explain ? |
|
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-06-08 : 09:08:27
|
| I mean before inserting to actual table you can run replace function by using execute sql task.Thanks Sanjeev |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-06-08 : 09:32:35
|
| If you're using a Data Pump task, can't you specify the double quote as a text qualifier then make the delimiter a space character? (Sorry It's been a while since I used it, and I don't have access to DTS to check since we moved over to SS 2005).Mark |
|
|
|
|
|
|
Importing a text file