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.