Linking Access to SQL Server
Linking to data in SQL Server from a Microsoft Access database
top of page
Search
Kimberlee Martin
- Jan 11
- 4 min
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
2 views0 comments
Kimberlee Martin
- Jan 5
- 6 min
Linking Access to Excel Data
Create a Microsoft Access table that is linked to an Excel file.
8 views0 comments
Kimberlee Martin
- Jan 3
- 5 min
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.
2 views0 comments
Kimberlee Martin
- Dec 22, 2022
- 3 min
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 series, and our topic is getting the cleaned data back to Excel. To recap, my premise is this: Microsoft Access has lots of tools that can help you clean up your Excel data. I’ve covered many of them in the last few posts, including the find duplicates query, update queries and several useful functions. Here are links to the other articles in
5 views0 comments
Kimberlee Martin
- Dec 19, 2022
- 4 min
Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.
7 views0 comments
Kimberlee Martin
- Dec 12, 2022
- 6 min
Using Access to Clean Excel Data, Part 4
Use MS Access to find duplicates in your Excel data
5 views0 comments
Kimberlee Martin
- Dec 6, 2022
- 2 min
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 can leverage to validate any Excel data. Then I covered some phone number validations you might add to that harness. Today I’m going to talk about using that harness to automatically replace text that a user may enter. I consider this part of data validation, because you can use it to head off data issues. Here’s an example: Converting "K" to
6 views0 comments
Kimberlee Martin
- Dec 2, 2022
- 4 min
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
9 views0 comments
Kimberlee Martin
- Dec 1, 2022
- 5 min
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
7 views0 comments
Kimberlee Martin
- Nov 28, 2022
- 6 min
Parse Phone and Extension with VBA
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 that allows you to add custom validation as users are entering data. Now that we’ve laid that framework, we can work on adding some useful validation. Phone Numbers and Extensions Today, we’re going to look at phone numbers and extensions. When setting up an Excel file, it’s common for people to create a single column that is used for both, as
9 views0 comments
Kimberlee Martin
- Nov 23, 2022
- 6 min
Validate Phone Numbers in Excel
Use Excel's formatting and data validation features to validate phone numbers
5 views0 comments
Kimberlee Martin
- Nov 21, 2022
- 6 min
Using Access to Clean Excel Data, Part 2
Use MS Access to clean phone numbers in your Excel data.
15 views0 comments
Kimberlee Martin
- Nov 18, 2022
- 9 min
Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.
7 views0 comments
Kimberlee Martin
- Nov 16, 2022
- 6 min
Validating a State in Excel
Use Excel tools to validate a U.S. state.
4 views0 comments
Kimberlee Martin
- Nov 14, 2022
- 5 min
Using Access to Clean Excel Data, Part 1
Excel data can be messy. Use MS Access features to clean it up.
17 views0 comments
Kimberlee Martin
- Nov 7, 2022
- 3 min
Debugging VBA without Line Numbers
I wrote a post several years ago about adding line numbers to your VBA code. To this day, it remains my post popular post ever. Why? It’s because they can be a useful tool in your debugging arsenal. Taking a walk down memory lane, old-school computer programmers will remember that line numbers were crucial back in the day. Whenever there was a problem with your program, you were always referred to a particular line number, identifying the command that was failing, which gave
4 views0 comments
Kimberlee Martin
- Nov 4, 2022
- 7 min
Appending Excel Data to an Access Table
Use an append query to add Excel data to an Access table
11 views0 comments
Kimberlee Martin
- Oct 25, 2022
- 6 min
Importing Excel Data to Access
Tips for making your Excel data import smoothly into Access
20 views0 comments
Kimberlee Martin
- Jun 7, 2022
- 3 min
Dynamic Highlighting in Excel
Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge, so I’ll share it with you here. The customer has a list of part numbers and their components. When they select a component part number, they want to quickly find all parent part numbers that contain that component. The parent part number is in column A, and the component part number is in column B. Here’s an example: Notice that the parent p
23 views0 comments
CATEGORY
ARCHIVE
bottom of page