Connections: Importing CSV Data from your Software Package into Excel
Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.
top of page
Search
Kimberlee Martin
Dec 22, 20223 min read
Using Access to Clean Excel Data, Part 5
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...
19 views0 comments
Kimberlee Martin
Dec 19, 20224 min read
Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.
20 views0 comments
Kimberlee Martin
Dec 16, 20224 min read
Double Trouble
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...
15 views0 comments
Kimberlee Martin
Dec 12, 20226 min read
Using Access to Clean Excel Data, Part 4
Use MS Access to find duplicates in your Excel data
14 views0 comments
Kimberlee Martin
Dec 6, 20222 min read
Auto-replace Text in Excel Cell with VBA
In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...
25 views0 comments
Kimberlee Martin
Dec 2, 20224 min read
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
22 views0 comments
Kimberlee Martin
Dec 1, 20225 min read
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
13 views0 comments
CATEGORY
ARCHIVE
bottom of page