Kimberlee MartinJan 27, 20233 minVBA: Data Type ConversionVBA's automatic type conversion feature sometimes causes it to concatenate instead of add.
Kimberlee MartinJan 20, 20234 minConnections: Bringing SQL Server data into ExcelAdd a link to SQL server data to your Excel worksheet.
Kimberlee MartinJan 17, 20236 minConnections: Bringing SQL Server data into AccessLinking to data in SQL Server from a Microsoft Access database
Kimberlee MartinJan 11, 20234 minVBA DatesExcel and MS Access store dates as numeric fields, allowing for each calculations in VBA.