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.

People who use Microsoft's productivity apps on the Mac PC platform sometimes can get ... in Excel for Mac over the last few years, such as the ability to import data from SQL Server databases.

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 ...