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 |
|
amejiae
Starting Member
2 Posts |
 Posted - 2006-03-29 : 09:20:51
|
| Hi there,This question is about isql, i'have to create a .bat to export a Stored procedure result to a txt file, but i use the column separator ';' but it does not work, it ommits several ';' and i cannot export that file to excel or access.this is the .bet file that using:isql -Usa -SISSERVER -Ponline -s; < EjecutarT1P.sql > D:\Verificar_bd\resultado_bd2.txtThe problem is that i cannot export this file to excel or access or sql server because isql does not separate all columns with ';'if someone can help me i'll be very thankfullBest regardsAlejandro mejia |
|
|
Pat Phelan
Posting Yak Master
187 Posts |
Posted - 2006-03-29 : 13:03:12
|
| Are you using ISQL or OSQL? Which version of SQL Server are you using (specifically, which version of ISQL.EXE are you using, what filesize in bytes and date stamp does it have)?-PatP |
 |
|
|
amejiae
Starting Member
2 Posts |
Posted - 2006-03-29 : 13:09:38
|
| i'm using isql and the database is sybase, but the problem i think is from isql and his query results.The version is 11.1 and the filesize of the results is 600k |
|
|
|
Pat Phelan
Posting Yak Master
187 Posts |
Posted - 2006-03-29 : 13:52:39
|
| I'd suggest that you post this question in a Sybase forum like http://www.dbforums.com/forumdisplay.php?f=6. I'm 99.5% sure that the problem is in the ISQL.EXE implementation, and I don't have a Sybase system to test it.-PatP |
|
|
|
|
|
|
isql question