So, I’ve been getting a lot of hits on my posts for generating Oracle SQLLDR control files from excel, and such.
For those of you out there, I’m happy to help y’all out any way I can. VBA is fun, and useful, and the more I do the more I learn. Mostly I focus [...]
So, recently, my wife started making a stink about how rape jokes aren’t funny.
She also showed me a few skits and such (by guys I like) that used rape as a gag.
And, the fact is, she’s right. It’s not cool to make rape jokes.
But I honestly couldn’t tell you why. I mean, if [...]
And another tool I use a lot.
I often get asked to export all the (relatively small) tables in a schema into worksheets in an excel workbook, one per tab.
Usually, theres a back and forth first with me trying to explain how this probably won’t mean much, the user
not understanding, me explaining, the user either not [...]
Just a little geek moment here.
For my job, I do a lot of dataloads. Its actually kind of annoying because ctl files are kind of annoying.
ANYHOO, I got tired of writing the things and the typos and such, so I made a little VBA app in Excel.
The code assumes that the column names are [...]
My company is taking bids for new health insurance providers. To facilitate this, one of the bidders is requesting detailed information about each employee. Basically, I’m filling out the form I’d be filling out if I were signing up.
This is a whopping great pain in the ass for a number of reasons, but [...]
Here’s my weekday:
Wake up around 6am
Leave for work around 7:15
Get home around 7:00
Eat
TV (Daily Show, Colbert, probably one other)
Bed around 10:30
This sucks. My workday isn’t bad, but the wife (who I commute with) has a 9 hour day, and our commute itself is about 75 minutes (mostly on the metro). I don’t actually mind the [...]