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…
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.
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.
Sorry to rub it in, really…
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.