Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Doing a dump
- Thread starter meeble
- Start date
One easy way you may use to export to a text files is to use Microsoft Access. Create an ODBC connector to the database, Link to the tables, and export the content of the database to a csv file. You should create a file for each of the table you want.
You can also use the BCP application that come with SQL server but it need a little reading before you use it.
You can also use an ODBC connection using MS Excel and save the content to CSV.
It is up to you!
You can also use the BCP application that come with SQL server but it need a little reading before you use it.
You can also use an ODBC connection using MS Excel and save the content to CSV.
It is up to you!
- Status
Similar threads
- Locked
- Question
- Locked
- Question