Connections: Bringing SQL Server data into Excel
Add a link to SQL server data to your Excel worksheet.
Connections: Bringing SQL Server data into Excel
Connections: Bringing SQL Server data into Access
Connections: Importing CSV Data from your Software Package into Excel
Doubles, but No Troubles
Double Trouble
Using Access to Clean Excel Data, Part 4
Validating Numeric Fields in Excel
Using Access to Clean Excel Data, Part 3
Validate Phone Numbers in Excel
Using Access to Clean Excel Data, Part 2
Validation Harness in Excel VBA
Validating a State in Excel
Appending Excel Data to an Access Table
Connections: Importing Excel Data into Access
Making the Most of Excel – Data Validation
Data Accessibility
Tips for Structuring your Excel Data
Protecting Data on an Access Form
Access or Excel?