vba

Using ADO and Jet Microsoft offers a way to view a folder, containing delimited text files, as a database where each file is a table.
The perspectives in this are great; you can perform joins, filtering, aggregation etc. without resorting to parsing techniques - you get to write sql queries instead!
In the example below I demonstrate [...]

In a project at work I use Excel to perform analyses of some data records, which are timestamped by date and time.
I want to categorize the records by their time-of-day eg. “morning” and “afternoon”.
For this I define what is the beginning and end of each category eg. “morning”: from 07:00 to 09:00.
To find the category [...]