Connection Properties
Use properties of Excel connections to gain access to real-time data points in your database.
Connection Properties
Access Database Corruption
VBA Overflow Error
Connecting Data Sources in Excel
Connections: Linking Access to Access
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
Connections: Importing CSV Data from your Software Package into Excel
Using Access to Clean Excel Data, Part 5
Doubles, but No Troubles
Double Trouble
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