Access2000 to Oracle will not append

[rjurgens]

I am trying to export a table from Access 2000 to
Oracle. It works fine if I create a new table in Oracle, but I get an error when trying to append to an existing
Orable table.
Here is the code I am using.
DoCmd.TransferDatabase acExport, "ODBC", "ODBC;DSN=ADMIN;SERVER=TEI1;;TABLE=HANDSET_USAGE", acTable, "HANDSET_USAGE", "HANDSET_USAGE_TEMP", False

 

[psemianonymous]

You can maybe do:

"DROP TABLE [tablename]"

and then run the import, that way the table is guaranteed gone before you run that line.


Really, though, you shouldn't have to re-delete the table definition every time. Assuming the structure stays the same, simply run a "DELETE * FROM [tablename]", then a "INSERT INTO " statement to append everything into the table.

 

[rjurgens]

Thanks. I can not drop the table because all the table properties are no longer there (such as Nulls and default values). I did think of the INSERT statement, but the user will have a choice of inserting data into 200+ different tables in Oracle. Some of those tables have over 50 columns. It probably would take a while to create statements for all of them.