Using Delphi 5, I am trying to transfer an Interbase table to disk.
The idea is to allow an export followed by an import to replace a
table with an updated one from another PC.

I think the SQL looks something like this to create the table:

CREATE TABLE NewTable EXTERNAL "A:\MyTable.txt"
(FIELD1 VARCHAR(3),FIELD2 VARCHAR(10))

Then, to move the records to the new table, something like this:

INSERT INTO NewTable SELECT * FROM SourceTable

In this example, SourceTable is an Interbase table.

I haven't worked on the subsequent import yet.

Delphi is returning an EIBInterbaseError error because of something
wrong with the CREATE TABLE statement above. The error reads "Token
unknown EXTERNAL".

I have 2 questions:

1) What is wrong with the CREATE TABLE SQL statement above?

2) Can you recommend a good web resource for this type of SQL
formatting question in the future?

Currently I am using the book "SQL for Dummies" but it sometimes does
a poor job of showing how to format a statement.

Thank you!

- Dale Francis.