Access, I thought I was done with you

Last Updated on Thursday, 21 June 2007 08:36 Written by Steve Thursday, 21 June 2007 08:36

I’m in the middle of a data migration from ebase 2.0, and I haven’t spent this much time using Access since 1997. I cut my teeth on Access 2.0 and am pretty comfortable in the app–it has proven invaluable in the data migration process. In this case I’ve built a system that steps through a process for transforming data out of the ebase 2.0 schema and into the Salesforce.com schema.

There are a couple steps in the process…

ebase2steps.png

Comments

Powered by Facebook Comments

This entry was posted on Thursday, June 21st, 2007 at 8:36 am and is filed under CRM, Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Comments

  1. Scott Hemmeter   |  Thursday, 21 June 2007 at 2:38 pm

    Nice! I don’t miss having to do that. I’ve used Access on many occasions for the same purpose. It actually works great, but can be a lot to work with. It’s better than writing scripts, though.

    Suggestion for you. Add all your steps into a single Macro so all you need to do is double-click and wait. :)

  2. Chris   |  Sunday, 24 June 2007 at 8:17 pm

    Agreed with Scott on all counts. I have to say, this is one of the reasons I love being part of a bigger organization – someone else has to do all the migration wrestling. :-P Sorry to rub it in, really…

  3. Gareth Davies   |  Monday, 25 June 2007 at 11:53 am

    Just a note on creating tables – if you run the developers’ side kick and export in XSD format you can read that into Access and it will create tables & columns for you.

    G.

Leave a Reply