Posted to microsoft.public.excel.programming

Dexter[_2_] Dexter[_2_] is offline

external usenet poster

Posts: 1

Convert Columns to Rows

Old fashion way, works on multiple versions of Oracle.

Save your Excel file as comma separated values file (*.CSV).

Create table in Oracle with your Oracle table column names same as your
spreadsheet.

Use Oracle SQLLoader function to load the data from the CSV file into
the Oracle table.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert rows to columns	David	Excel Discussion (Misc queries)	5	November 22nd 08 02:58 PM
convert columns to rows	DHM	Excel Worksheet Functions	4	June 30th 07 02:52 AM
Convert rows to columns	lucrezia	Excel Worksheet Functions	0	June 28th 07 06:36 PM
to convert columns to rows having mulit independent group columns	Quacy	Excel Worksheet Functions	1	August 22nd 06 11:20 PM
Can I convert columns to rows?	Adam@Penda	Excel Discussion (Misc queries)	3	January 11th 05 07:35 PM

All times are GMT +1. The time now is 12:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us