Does anyone have specfic examples ?




"Tim" wrote in message ...
Erik,

I believe the only way you can upload data to an Oracle DB
is to loop through your rows. You will need Oracle client
installed on the PC you are uploading from. I would
recommend creating an ODBC connection to simply the
creation of the connection object (obviously the TNSblock
must be set). I would recommend using the Command object
and appending parameters to it rather than concatentating
values into a single string (unless your values are really
simple, no chance of an apostrophe or quotation marks in
the uploaded values).

-Tim

-----Original Message-----
I'm trying to insert data from Excel into Oracle.

I have a couple questions regarding this topic:

1) What is the syntax to insert multiple rows (Do I need
to loop through each row ?)

2) What is the syntax to insert multiple rows from
multiple columns.

Thanks for your assistance.
.