pynchmeawake
New Member
- Joined
- Jan 11, 2015
- Messages
- 2
Apologies if this is more of an Oracle question.
I wish to load a table with more than 1 million rows to an Oracle database. The data is provided to me in separate Excel spreadsheets, each with less than 1 million rows.
I may be able to get the supplier to fit all of the data in one spreadsheet by creating a Data Connection that outputs data (from the supplier's database) directly to a Pivot Table rather than to a Table, so the raw data itself is not displayed on a worksheet.
If so, is there a way to reference the data behind the Pivot Table so that Oracle can read it as a normal table?
I wish to load a table with more than 1 million rows to an Oracle database. The data is provided to me in separate Excel spreadsheets, each with less than 1 million rows.
I may be able to get the supplier to fit all of the data in one spreadsheet by creating a Data Connection that outputs data (from the supplier's database) directly to a Pivot Table rather than to a Table, so the raw data itself is not displayed on a worksheet.
If so, is there a way to reference the data behind the Pivot Table so that Oracle can read it as a normal table?