Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to export selected columns to SQL Server without programming? | Excel Discussion (Misc queries) | |||
Export to Excel 2003 from Oracle Discoverer 9i | Excel Discussion (Misc queries) | |||
How to get data from Oracle Database to Excel? | New Users to Excel | |||
Macro to Export Selected fields to an Existing Access Database | Excel Programming | |||
Export from Oracle into Excel, "Open" is not an option in XP | Excel Discussion (Misc queries) |