VBA: Data Type Conversion
VBA's automatic type conversion feature sometimes causes it to concatenate instead of add.
VBA: Data Type Conversion
Connections: Bringing SQL Server data into Excel
Connections: Bringing SQL Server data into Access
VBA Dates
Connections: Bringing Access Data into Excel
Connections: Bringing Excel Data into Access
VBA: Three Ways to Handle Text in Numeric Fields