VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
VBA Dates
Connections: Bringing Excel Data into Access
VBA: Three Ways to Handle Text in Numeric Fields
Using Access to Clean Excel Data, Part 5
Doubles, but No Troubles
Using Access to Clean Excel Data, Part 4
Auto-replace Text in Excel Cell with VBA
Validating Numeric Fields in Excel
Using Access to Clean Excel Data, Part 3
Parse Phone and Extension with VBA
Validate Phone Numbers in Excel
Using Access to Clean Excel Data, Part 2
Validation Harness in Excel VBA
Validating a State in Excel
Using Access to Clean Excel Data, Part 1