| Author |
Topic |
|
Jason100
Starting Member
34 Posts |
 Posted - 2008-09-12 : 04:41:38
|
| This is a documentation like a.bcp.How to load the *.bcp documentation to database? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-12 : 04:45:47
|
what is a.bcp ? Is this a text file ? You can use BCP or BULK INSERT or DTS or SSIS to import into the table.Check out all these in the Books OnLine.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-09-12 : 04:48:00
|
| I try to run the following sql . But it can not work.EXEC master..xp_cmdshell 'bcp jason.dbo.test in D:a.bcp-c -T' |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-12 : 04:55:25
|
run that in command prompt first and see what is the error message ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-09-12 : 04:58:37
|
| run that in command prompt first and see what is the error message ?This is nothing message output. but the table has still not data |
|
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-09-12 : 05:04:03
|
| I suspect that it's a bad documentation . I can not open with notepad. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-12 : 05:14:24
|
quote:
Originally posted by Jason100
I suspect that it's a bad documentation . I can not open with notepad.
what bad documentation ? Which documentation are you referring to ?You can't open what with notepad ?What is file a.bcp ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-09-12 : 05:20:18
|
| This is table which output with bcp. But now I can't open this a.bcp with notepad . |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-09-14 : 17:38:42
|
if the file was exported with bcp using native format, then it would ba a binary file and would not be intelligible in notepad.
elsasoft.org |
|
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-09-15 : 22:32:50
|
| jezemineHow to load those data to database? |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-09-16 : 02:02:01
|
with bcp. see the -n and -N switches in BOL.
elsasoft.org |
|
|
|
|
How to load the *.bcp documentation to database