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

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

Microsoft Excel ... required data and display the HTML on your Web page. Use a DSN-less connection (i.e. with no data source defined on the server) to connect the program to your database for ...

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.