Naming and Typing the fields correctly should work. However, you can also create a comma-delimited ASCII file with this command:
COPY ALL TO MYFILE.CSV TYPE DELIMITED
and in the new file:
APPEND FROM MYFILE.CSV TYPE DELIMITED
If you don't have the fields in the same order, make the first command be:
COPY ALL TO MYFILE.CSV FIELDS FNAME, LNAME, ADDRESS (ETC.) TYPE DELIMITED
JR
>Because I have change the table structure, even I rename the old
>backup copy to the original name. I still fail to add to original
>Database... What can I do then??
>
>If fail to got the table in, fail to copy to new table structure...
>Oh... ~~~><~~~
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com(941) 743-0108
(800) 246-5488