January - 2023

Search

VBA: Data Type Conversion

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

Connections: Bringing SQL Server data into Excel

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

Connections: Bringing SQL Server data into Access

Linking to data in SQL Server from a Microsoft Access database

VBA Dates

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

Connections: Bringing Access Data into Excel

Creating links to Microsoft Access data in your Excel worksheet.

Connections: Bringing Excel Data into Access

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

VBA: Three Ways to Handle Text in Numeric Fields

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

CATEGORY