Access, I thought I was done with you
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…
June 21st, 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.
June 24th, 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.
Sorry to rub it in, really…
June 25th, 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.