[2005] SQL Commands to export tables to text file

[lowlyhack]

I am trying to write my first app here. It is a form that asks the user for their SQL server name, database admin username and password, amongst other things. I was hoping to use the variables in the text boxes to populate the parameters of a command line (using process.start) such as this example:

isql.exe -S%SERVER% -U%USERNAME% -P%PASSSWORD% -d%DBNAME% -i%INPUTFILENAME%.sql -s| -n -w500 -o%CUSTOMERNAME%_01.txt

I felt after seeing the post here:
http://www.vbforums.com/showthread.php?t=458555
that my decision to use process.start may be a little inelegant.

Please tell me I'm on the right track here. I want to take the input from the form, run SQL queries that will export the tables to text files (then send the text files to an ftp server - but that's another issue)

Thanks

[penagate]

If you don't need to manipulate any data within your application then using the command line is the right solution.