If you move data from Excel to Access on a regular basis, you’ll know that sometimes Access can’t resolve the data being imported from Excel. In these cases Access automatically creates a new table called ImportErrors..
. » More: Clearing Access ImportError Tables
Posts Tagged ‘Access’
Clearing Access ImportError Tables
January 26th, 2010Using Dashboard Graphics in Access
January 7th, 2010Let’s face it, Access isn’t typically a tool you would think of when considering a dashboarding platform. The reporting tools in Access, as slick as they are, don’t lend themselves to visualizations.
That is, Access doesn’t offer a whole lot in the way of dashboarding graphics. Sure, it has charts and conditional formatting, but nothing like Excel.
In this post, I’ll show you a hack to spruce up your Access reporting by using your own dashboarding graphics.
The Benefits of a Good Technical Editor
December 4th, 2009I’m in the process of writing my Pulitzer worthy book “An Excel Analyst’s guide to Access”. During the writing process, chapters get reviewed by a team of editors – one of which is a Technical Editor.
The Technical Editor on this book is Dick Kusleika (Daily Dose of Excel). Kusleika is one of the better technical editors I’ve worked with. I think his accountant’s detail-oriented brain lends itself nicely to tech editing.
Quick Joke: Did you hear about extroverted accountant? He looks down at your shoes.
.
During his editing, Kusleika pointed out that that the serial dates in Access actually start at December 31, 1899 (not January 1, 1900 like in Excel).
Easily Move Access Query Results to Excel
November 19th, 2009Just the other day, I saw someone run an Access Query in Office 2003. Then he selected Office Tools ->Analyze with Excel. This essentially sends the results of the Access query to Excel.
.
This if fine and dandy, but there is a slightly easier way to get the results of an Access query to Excel.
Creating System Tables in Access
November 6th, 2009I’ve got a lot of writing to do today and this weekend. So today’s post will be quick and sweet.
Did you know that you can create your own system tables in Access? That’s right; you can create tables that act like system tables.
Here’s how to do it:
Documenting Access Queries in Excel
October 26th, 2009Clients usually have this pesky need to have everything documented. As a generally lazy person, this offends my lackadaisical attitude. Nevertheless, I typically oblige, given the fact that I want them to take over the work at some point.
Over the years, I’ve rolled my own documentation tools to help in this endeavor. Today, I want to share a small procedure I use to document Access queries in Excel.
Getting to Workdays in Access
October 22nd, 2009Suppose you’ve been asked to provide some reporting in Access, but only for those dates that are company workdays (workdays are defined as days that are not weekends or holidays). In Excel, you have the NETWORKDAYS function to help you out. But in Access, you’re on your own. There is no such function in Access.
Well, it’s your lucky day. Today, I’ll show you an easy way to query only workdays in Access.
Running an Access Parameter Query from Excel
October 19th, 2009An Access parameter query is a kind of interactive query that prompts you for criteria before the query is run. Parameter queries are useful when you need to ask the query different questions using different criteria each time you run it.
Now we all know you can pull data from Access into Excel using MS Query. The problem is that MS Query doesn’t let you pull in Parameter queries. There may be a technical reason for this, but I like to think it’s just Microsoft’s way of keeping things interesting. After all, technical roadblocks are the spice of life.
If you’ve had enough spice, I’ll show you a VBA workaround that will enable you to run an Access parameter query from Excel.
Sending Variable Access Data To An Excel Range
September 28th, 2009Today, I ‘d like to show you a nifty trick that will allow you to send Variable length tables from Access to a specific Excel Range without code.
That’s right, I said without any VBA coding. I know you’re as excited as I am, so here we go.
Why Replace the DOM Interface
September 23rd, 2009Here’s a question for you super-geeks out there. Why would Microsoft create its own object designed to traverse XML documents?
I don’t normally get into the high-minded technical side of Excel and Access. But I do use XML quite a bit in my work with Xcelsius. Last year, I noticed that Microsoft introduced new objects with Office 2007: The CustomXMLPart object, and the CustomXMLNode object.
