In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database ... script to clear the Microsoft sample ...

a SQL Server database or even a large text file, you can also retrieve data from it using Excel. Using SQL statements in Excel enables you to connect to an external data source, parse field or ...

While Microsoft Excel is ... can also import data directly from web pages (from the HTML structure of the page) and even external databases like Microsoft Access or SQL Server.

There are times as a developer that you will want to be able to delete all the data from a database as ... system for a very large medical database on a server with a slow DSL connection. I needed to ...