How do i export selected columns from excel to an Oracle database
 

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

How do i export selected columns from excel to an Oracle database
 

I'd suggest trying it from the Oracle end. Good Luck.
Sincerely,
--
Gary Brown

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

How do i export selected columns from 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" wrote in message ...
How do i export selected columns (some from many) from an excel to an Oracle
database

How do i export selected columns from 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.