
Importing existing data to Interbase from MS Access or Excel
Hello delphi Users!
I'm rewriting an existing MS Access application using Delphi and
Interbase. I need help getting the DATA out of Access and into
Interbase. (Copying the Table/Field/Relationship structure from Access
to Interbase was easy, using ER/Studio.)
In the future, I'd like to give the user a convenient method of
importing data from Excel to Interbase. Maybe a wizard-type interface,
where they can way what Excel column maps to what Delphi/Interbase
field.
So I need a way to import data from Access to Interbase, and from Excel
to Interbase.
I have already created the tables I want in Interbase (I created an
Interbase DDL script by using Embarcadero's excellent CASE tool,
ER/Studio 2.0 available for evaluation from www.embarcadero.com, to
reverse-engineer the Access database schema and then generate an
Interbase schema).
I tried using Delphi's Data Pump (Data Migration Wizard) but it doesn't
let me set up field-to-field name mappings for the import process.
Ideally, I would like to have the option to map an Access field name (or
Excel column header) to a different field name in my Interbase database.
Is there a built-in component in Delphi for importing?
Are there any third-party components that do it?
Any ideas you may have would be greatly appreciated.
Scott Alexander