| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Oracle Dbase over 65k rows
If you use ADO to retrieve your data,
1. Create the Recordset Object 2. Set the PageSize property to 65, 535 (first row is for column names) 3. Open your recordset 4. Loop though the Recordset by Page, adding a new worksheet for every page a. write the column names to row 2 b. write all the data for the page at A2 using the CopyFromRecordset object |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Oracle import | Excel Worksheet Functions | |||
| Import Data from Oracle to Excel | Excel Discussion (Misc queries) | |||
| Import Dbase data Using VBA | Excel Programming | |||
| how do I import data from oracle version 7 to excel 2002 | Excel Discussion (Misc queries) | |||
| Import Dat from Oracle - pls help | Excel Programming | |||
Hybrid Mode
