DataWright Information Services

Consulting and Resources for Excel and Access

Welcome

Welcome to this site. We have put together a number of resources for Access and Excel, which we hope you will find useful.

Update 21 September 2012: As I have now taken up a full-time job, I am not taking on any new consulting work but I continue to support existing clients. I have also started a blog where new articles will be posted. Because the articles on this site have been in the search engines for a while I will keep the site going as an archive. Hope to see you at the new site!

Talks and presentatons

On 6 November 2010 I gave a talk on Integrating Access and Excel at Office Devcon 2010, in Sydney.

The talk showed how to use Access as a data store for Excel, and included sections on:

  • Using ADO from Excel -- an updated version of the articles on this site
  • Using VBA to create pivot tables based on Access data
  • And two short snippets on
    • Drilling down into Excel reports
    • Cleaning up timestamps in CSV files

You can download the presentation and the sample files here.

Last updated 24 May 2013 16:45

Other files

These files don't fall into the normal category of files on this site. They will be added to periodically, and you are welcome to download and use them.

Last updated 09 Mar 2009, 20:45

Latest additions and updates

Here are the latest additions or updates to the site, most recent at the top of the list:

Last updated 24 May 2013 16:45

If you would like us to assist you with any of the ideas on this site or to provide an obligation-free quote, please contact us to arrange a meeting.