VBA's automatic type conversion feature sometimes causes it to concatenate instead of add.

Add a link to SQL server data to your Excel worksheet.

Linking to data in SQL Server from a Microsoft Access database

Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.

Creating links to Microsoft Access data in your Excel worksheet.

Create a Microsoft Access table that is linked to an Excel file.

Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.