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:
The problem is that i cannot export this file to excel or access or sql server because isql does not separate all columns with ';'
i'm using isql version is 11.1 and the database is sybase, but the problem i
if someone can help me i'll be very thankfull
all solutions you provided works, but the problem is the results that isql drops to me i already separated all my columns with ';' but the txt file that it dropss is badly formed to be exported to excel, access, sql serve or any BD engine, Is there another way to export a result set from sybase without using isql????
additionally to that, i am using WinSql to perform querys and to esport my result to a txt file, in this i have to use isql because i need to exporta a result set to a txt file automatically so i use the .bat file that i mentioned before
"Get External Data"
"New Database Query"
Then choose your ODBC data source and make sure "Use the Query Wizard" is not ticked
Instead of clicking on a table to build a new query, close the Add Table window
Then click on
enter the command to run your procedure e.g. exec sp_helpdevice
"Return Data to Microsoft Excel"