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

K

Kostas

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

Tim Williams

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.
 
G

gimme_this_gimme_that

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to change Crystal Reports settings from Oracle to SQL 0
VBA Export to PDF 0
Which Oracle home does VBA use? 1
Get status messages from Oracle sql queries 0
Merging from an Excel file with graphics 1
Solved Disk Full error message when exporting PDF 0
Linking Access and Oracle Database 2
Images are pixelated when saving to PDF 0

Top