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.

Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.

I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that...

Use VBA to check for nearly identical data in your Excel worksheet.

Today we’ll be looking at preventing duplicate values from being entered into your Excel sheet. This is the final entry in a series that...

Use MS Access to find duplicates in your Excel data

In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...

Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.

Use MS Access to clean numeric fields that contain text.

Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...

Use Excel's formatting and data validation features to validate phone numbers

Use MS Access to clean phone numbers in your Excel data.

Adding a Visual Basic structure to your Excel file for validating data.

Use Excel tools to validate a U.S. state.