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 |
|
petek
Posting Yak Master
192 Posts |
 Posted - 2009-10-19 : 09:35:47
|
| Hi,Is there a way to export query results to a csv file?cheersKind RegardsPete. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-10-19 : 09:38:57
|
FILE - SAVE RESULT AS
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-10-19 : 09:41:13
|
| sorry i should have said; it needs to be from t-sql automatically when i run a script.....Kind RegardsPete. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-10-19 : 09:47:04
|
use BCP OUT or BCP QUERYOUT
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-19 : 09:48:04
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-10-20 : 03:47:08
|
| Hi i should have said its a x64 install and i get the following error.....Msg 7403, Level 16, State 1, Line 109The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.Kind RegardsPete. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-20 : 03:51:36
|
| Have you tried bcp command?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Export from query window.....