Importing existing data to Interbase from MS Access or Excel 
Author Message
 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



Wed, 18 Jun 1902 08:00:00 GMT  
 Importing existing data to Interbase from MS Access or Excel

Have you setup the ODBC driver for Interbase?  Excel and MS Access can read
and write Interbase databases via ODBC.
Gene



Quote:
> 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




Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Importing existing data to Interbase from MS Access or Excel

2. How to import PARADOX 7.0 into MS Excel????

3. How to import paradox 7.0 into MS Excel?

4. How Delphi use Ms Excel data?

5. Transfer Data To MS Excel Format

6. Importing Paradox data into an InterBase database

7. Q: Import Dbase-Data into Interbase SQL ?

8. Access MS Excel with ADO

9. Accessing MS Excel

10. Accessing MS Excel 5 (*.xls) files

11. Accessing MS Access 97 data from Delphi 3

12. How to append fields to existing tables, without damageing the existing data

 

 
Powered by phpBB® Forum Software