| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet
I am having a table which holds more than 5 lakhs of records.I want
to copy all these records into a Excel Workbook in such a way that first 60,000 records are inserted into one sheet then automatically new worksheet is added and another 60,000 records added and so on the new sheets are inserted for every next 60,000 records. I used CopyfromRecordset method but this is of no use as the records which overflow are not added into new sheet.. numberofrows = Sheets("INDATA").Cells(2, 1).CopyFromRecordset(RSDPrt) Kindly let me know a method to do this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
| Filter records in a table to extract to another table | Excel Discussion (Misc queries) | |||
| Using Excel to change/add/delete records in Access database | Excel Programming | |||
| Is it possible to update records in an Access table from Excel? | Excel Programming | |||
| Adding Records to Access Table | Excel Programming | |||
Threaded Mode
