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 |
|
Sanjay_Bakshi
Starting Member
14 Posts |
 Posted - 2008-07-20 : 06:12:14
|
| Dear All,I wanted to take backup of my all the file in .TXT format with "," delmiter.Please provide me with script.SanjaySanjay |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-20 : 06:43:47
|
How is this is related to SQL Server ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Sanjay_Bakshi
Starting Member
14 Posts |
Posted - 2008-07-20 : 06:46:58
|
| I am using SQL Server 2000Sanjay |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-20 : 22:28:34
|
| What do you mean 'take backup of my all the file in .TXT format with "," delmiter'? Load data in text file to sql table? Use bcp or bulk insert if so. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-20 : 22:31:55
|
Check out the Books OnLine on BCP, BULK INSERT, DTS
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-21 : 09:14:37
|
quote:
Originally posted by Sanjay_Bakshi
Dear All,I wanted to take backup of my all the file in .TXT format with "," delmiter.Please provide me with script.SanjaySanjay
Or use Export/Import wizard. |
|
|
|
|
|
|
SQl Backup