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 13
- 7 min
Access Database Corruption
Dealing with the "database is in an inconsistent state" error message, and other symptoms of Microsoft Access corruption.
00
Kimberlee Martin
- Mar 10
- 3 min
VBA Overflow Error
The Overflow error occurs in Visual Basic when you exceed the limits of a variable's data type.
10
Kimberlee Martin
- Mar 8
- 4 min
Connecting Data Sources in Excel
Using VLOOKUP data from Access and SQL Server databases
60
Kimberlee Martin
- Feb 20
- 4 min
Connections: Linking Access to Access
In recent blogs, I've been discussing the various ways you can connect data between Microsoft products. So far, I've covered Access,...
30
Kimberlee Martin
- Jan 27
- 3 min
VBA: Data Type Conversion
VBA's automatic type conversion feature sometimes causes it to concatenate instead of add.
30
Kimberlee Martin
- Jan 20
- 4 min
Connections: Bringing SQL Server data into Excel
Add a link to SQL server data to your Excel worksheet.
60
Kimberlee Martin
- Jan 17
- 6 min
Connections: Bringing SQL Server data into Access
Linking to data in SQL Server from a Microsoft Access database
90
Kimberlee Martin
- Jan 11
- 4 min
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
30
Kimberlee Martin
- Jan 9
- 4 min
Connections: Bringing Access Data into Excel
Creating links to Microsoft Access data in your Excel worksheet.
130
Kimberlee Martin
- Jan 5
- 6 min
Connections: Bringing Excel Data into Access
Create a Microsoft Access table that is linked to an Excel file.
90
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.
30
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.
70
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...
50
Kimberlee Martin
- Dec 19, 2022
- 4 min
Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.
70
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...
110
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
50
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...
70
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.
90
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.
70
CATEGORY
ARCHIVE
bottom of page