Connection Properties
Use properties of Excel connections to gain access to real-time data points in your database.
top of page
Search
Kimberlee Martin
- Mar 8
- 4 min
Connecting Data Sources in Excel
Using VLOOKUP data from Access and SQL Server databases
6 views0 comments
Kimberlee Martin
- Jan 20
- 4 min
Connections: Bringing SQL Server data into Excel
Add a link to SQL server data to your Excel worksheet.
6 views0 comments
Kimberlee Martin
- Jan 11
- 4 min
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
3 views0 comments
Kimberlee Martin
- Jan 9
- 4 min
Connections: Bringing Access Data into Excel
Creating links to Microsoft Access data in your Excel worksheet.
13 views0 comments
Kimberlee Martin
- Jan 5
- 6 min
Connections: Bringing Excel Data into Access
Create a Microsoft Access table that is linked to an Excel file.
9 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.
3 views0 comments
Kimberlee Martin
- Dec 28, 2022
- 5 min
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.
7 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...
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 16, 2022
- 4 min
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...
11 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...
7 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 23, 2022
- 6 min
Validate Phone Numbers in Excel
Use Excel's formatting and data validation features to validate phone numbers
6 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.
19 views0 comments
CATEGORY
ARCHIVE
bottom of page