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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-16 : 08:18:24
|
| latha writes "when i do a bcp queryout,the records from a table are exported to an excel file.In the first write alone the records are written missing one coloumn in the middle but the remaning records are written correctly.I am using sql server 2000" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-16 : 09:00:20
|
| Do you mean they are exported to a csv file?Have a look at the file and see if the column is there.If not look at the query.If it is then it is excel converting the data that is the problem and you may have to change the format.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
bcp export data to an excel file