Connections: Bringing SQL Server data into Excel
Add a link to SQL server data to your Excel worksheet.
top of page
Search
Kimberlee Martin
- Jan 17
- 6 min
Connections: Bringing SQL Server data into Access
Linking to data in SQL Server from a Microsoft Access database
9 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 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 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 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
Connections: Importing Excel Data into Access
Tips for making your Excel data import smoothly into Access
22 views0 comments
Kimberlee Martin
- Jun 9, 2021
- 4 min
Making the Most of Excel – Data Validation
Last week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today,...
19 views0 comments
Kimberlee Martin
- Aug 28, 2017
- 3 min
Data Accessibility
Just about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a...
22 views0 comments
Kimberlee Martin
- Feb 27, 2017
- 4 min
Tips for Structuring your Excel Data
Excel has some amazing report tools including charts and pivot tables. These tools are quick and easy to use, and produce some...
21 views0 comments
Kimberlee Martin
- Jan 20, 2017
- 4 min
Protecting Data on an Access Form
Microsoft Access allows you to quickly create forms for viewing and editing your data. One issue you may have run into with forms is that...
35 views0 comments
Kimberlee Martin
- Nov 30, 2016
- 4 min
Access or Excel?
Excel or Access? Microsoft has lots of great tools, and in most cases, it’s pretty clear which you need to use. If you need to write a...
20 views0 comments
CATEGORY
ARCHIVE
bottom of page