Subscribe
Tutorial search

Excel Database Tutorials


Sort by:
DAVERAGE Function
DAVERAGE Function
The DAverage function in Excel is used to calculate the average of values in database based on entered criteria.
Difficulty:
Add or Update your SQL database with Excel
Add or Update your SQL database with Excel
Best part of this hack is that you do not have to have much SQL skills or programming skills to update your database.
Difficulty:
Use Excel 2001 And Query To Retrieve External Data
Use Excel 2001 And Query To Retrieve External Data
Retrieving data from external databases and files is is superior to storing it locally for a number of reasons. It eliminates the task of retyping data to get it into Excel, decreases direct access to the information (decreasing the chance of data corruption or loss), and prevents unintentional updates to the data. By using Microsoft Query to retrieve data from external sources, you can analyze and manipulate it right in an Excel worksheet.
Difficulty:
Insert Data from Excel to SQL Server
Insert Data from Excel to SQL Server
Shows how to read data from an Excel spreadsheet and insert it into a SQL Server database using VBA and ADODB.
Difficulty:
Create Excel Spreadsheets Using Other Environments
Create Excel Spreadsheets Using Other Environments
Although Excel and other spreadsheet programs are the traditional interfaces for creating and reading spreadsheets, sometimes you might need to create .xls files directly from other programs.

Whether you're creating Excel files from databases on an Apache server or you just want to present the information stored in a Java program to Excel users, there are a variety of packages out there that will enable you to create and access .xls files without actually using Excel.
Difficulty:
Search Term(s) (1): database