Ingres Database Tables to Interbase???

[Chris Wolfe]

Hi All:

This is actually more of an Interbase question than 'pure' Delphi, but I
didn't know in what other forum to ask, so I thought I'd give it a shot
here. I hope someone can help with this.

I've got a number of files which were created by using SQL in Unix to
copy the data in several tables in an Ingres database. I really would
like to import this data into a new database created using Windows ISQL.

I've created the database and tables, then created a temp table using
the following (per the help files in ISQL):

CREATE TABLE TEMP_DATA EXTERNAL "C:\PROJECTS\TMP_DATA.DB"
(STUFF_NUMBER INTEGER,
STUFF_NAME CHAR(80),
EOL CHAR(1));

Executing returns no errors.

If I

SELECT *
FROM TEMP_DATA

I get exactly nothing - even though the help file suggests that I should
have all the data from my .DB file. I've got no data, even though I'm
sure that the TMP_DATA.DB file is chock full of priceless nuggets of
information.

I can find nothing which says that the output of a SQL Copy from and
Ingres database table is compatible with the input required for
Interbase, so I could really use some help. Has anyone else tried this?

Thanks,

Chris Wolfe