Kimberlee MartinJan 273 minVBA: Data Type ConversionVBA's automatic type conversion feature sometimes causes it to concatenate instead of add.
Kimberlee MartinJan 204 minConnections: Bringing SQL Server data into ExcelAdd a link to SQL server data to your Excel worksheet.
Kimberlee MartinJan 176 minConnections: Bringing SQL Server data into AccessLinking to data in SQL Server from a Microsoft Access database
Kimberlee MartinJan 114 minVBA DatesExcel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
Kimberlee MartinJan 94 minConnections: Bringing Access Data into ExcelCreating links to Microsoft Access data in your Excel worksheet.
Kimberlee MartinJan 56 minConnections: Bringing Excel Data into AccessCreate a Microsoft Access table that is linked to an Excel file.
Kimberlee MartinJan 35 minVBA: Three Ways to Handle Text in Numeric FieldsUsers will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.