Kimberlee MartinJan 20, 20234 minConnections: Bringing SQL Server data into ExcelAdd a link to SQL server data to your Excel worksheet.
Kimberlee MartinJan 17, 20236 minConnections: Bringing SQL Server data into AccessLinking to data in SQL Server from a Microsoft Access database
Kimberlee MartinJan 11, 20234 minVBA DatesExcel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
Kimberlee MartinJan 9, 20234 minConnections: Bringing Access Data into ExcelCreating links to Microsoft Access data in your Excel worksheet.
Kimberlee MartinJan 5, 20236 minConnections: Bringing Excel Data into AccessCreate a Microsoft Access table that is linked to an Excel file.
Kimberlee MartinJan 3, 20235 minVBA: Three Ways to Handle Text in Numeric FieldsUsers will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.
Kimberlee MartinDec 28, 20225 minConnections: Importing CSV Data from your Software Package into ExcelUse Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.
Kimberlee MartinDec 22, 20223 minUsing Access to Clean Excel Data, Part 5I’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...
Kimberlee MartinDec 19, 20224 minDoubles, but No TroublesUse VBA to check for nearly identical data in your Excel worksheet.