How do i export selected columns (some from many) from an excel to an Oracle
database

I'd suggest trying it from the Oracle end. Good Luck.
Sincerely,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Kostas" wrote:

> How do i export selected columns (some from many) from an excel to an Oracle
> database

You can use ADO and an Oracle provider to connect to the database, then use "insert.." SQL statements to insert the data.
You'll need the Oracle client software installed on the PC.

--
Tim Williams
Palo Alto, CA


"Kostas" <(E-Mail Removed)> wrote in message news:0371414E-9A06-44D9-96B5-(E-Mail Removed)...
> How do i export selected columns (some from many) from an excel to an Oracle
> database

Sometimes the fastest way to get data into Oracle is to loop through
the data in VBA and write a SQL script of insert statements. Then run
the sql script through sql*plus.