Saved Bookmarks
| 1. |
Solve : MS SQL data to text file?? |
|
Answer» is it possible to convert a mssql data to a text file using a batch file?Are you referring to MS Access or MS SQL Server? Access has a built in export facility on the file menu. With SQL Server you will need to write your own program or perhaps a script that can connect to the database. Do you know how to write the script to connect to MS SQL server? In order to keep down the embarrassment level, I have LEARNED not to post when there are too many variables to come to a clear solution. On the other HAND, some seemingly simple QUESTIONS have morphed into complex entities that required actual <gasp> research. Let hope this won't come to that. The easiest way to connect to SQL Server is using ActiveX Data Objects (ADO). Which VERSION of SQL Server are you using and what is the server name? The key to accessing a database is the connection string. The more information about your database you can provide, the easier it will be to write a script. An earlier response provided a link. Any reason it was not helpful? |
|