Maybe I knew this and had to relearn it, but was momentarily stumped when I needed to do some quick clean up and started to use the replace function. The syntax for it seemed strange: Turns out what I needed was Substitute. Here’s what the help page says: Substitutes new_text for old_text in […]Read more "Excel Substitute and Replace"
I had an SSIS package fail in a script task this morning. As part of the why process I opened up one of the files it was processing and got this message: I get the idea and I’ll hunt around to find what has it open, but I’m bemused at ‘another user’ which […]Read more "Another User Has Locked My File!"
This past week I needed to retrieve a spreadsheet from a Sharepoint library, add a column to a sheet, and then populate that column based on some data I had in Access. Rather than import the data into Access to make the change and then export back (which could overwrite any formulas, lose comments, etc), […]Read more "Another Strange MS Access Gotcha"
Recently I needed to help a colleague with a small inventory true up task. We needed to know items that were in List A and not in List B, and vice versa. It was a universe of about 1000 items with a good sized delta, 15 to 20 percent. For tools I had the options […]Read more "No Full Outer Join in Access"