How to Import All Files within a Folder to Your Access Table

Data, data, data – without it a database would be pretty useless. So it’s no surprise that one of the most frequently asked questions when it comes to getting that data into your Access table(s) is – how can I make my life easier when I have to regularly import lots (and lots!) of files? As it’s such a common task, there’s obviously a number of ways to skin that particular cat, but here we’re going to look at just one – in my opinion the easiest – especially if you’re doing this on a regular,...

Read more »

3 Quick Ways to Batch Convert Word DOC to DOCX Files and Vice Versa

In this article, there are 3 quick ways for you to batch convert Word doc to docx files and vice versa. Generally it’s been well-known that different Word versions save files in different types, with extensions like .doc or .docx. In team work, it’s likely that different members use different version of Word. Consequently, this leads to the difficulty of opening and editing sharing files. For example, you can’t open docx files in Word with version earlier before the 2007. Besides, you may be...

Read more »

2 Quick Methods to Get Your Outlook Contact’s Age

Sometimes, you may want to count your Outlook contacts’ age. But Outlook doesn’t have this function and manually counting will be error prone. Thus this article will introduce you 2 quick approaches via Outlook VBA. When creating new Outlook contacts, you can input the contacts’ birthdays. Then Outlook will automatically create the according recurring birthday events in your calendar. So when anyone’s birthday comes, you will receive a reminder. At this point, you must want to know the...

Read more »