How do I insert a whole Access table in Oracle ?

B

Balex

Hi

I have an Access app that reads and processes data from a Sybase DB, and
stores the processed data in one table in Access. That table has 62
attributes. I'd like now to "copy" the content of that table into an Oracle
DB. I've got access to DB and table, I can manually insert one row in the
Orcale table with values for the first 2 attributes of the table, so
everything would be ready.

BUT:
1) DoCmd.TransferDatabase, which I hoped would work (would be only one line
of code!) fails with "insufficient privileges"
2) Due to that, I very reluctantly moved to making a conventional INSERT
statement with my 62 fields. That consistently fails with "missing
expression" and drives me crazy, I've checked both the list of fields and the
list of VALUEs, and they match

I'm going bonkers trying to find out what is wrong. Can anybody tell me:
a) if there is an easier way than my complete SQL statement with 62 fields
and 62 values ? Can I use the <recordset>.AddNew and .Update syntax ?
b) if not, how do I quickly find out where Oracle finds an error in the SQL
statement ?

Thanks for help !
Balex
 
Top