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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Records from Access Database table(more than 5 lakh recordsin this table) to Excel Sheet
Is there really any value in doing so? While in Access you can work
effectively with very big numbers of records, this is more than I can say for Excel, especially if your data spans over multiple sheets. I suggest you consider working with Access instead. While Excel may be some sort of a software Swiss Army knife, you wouldn't consider cutting down a 100ft oak with it when you have a chainsaw available, would you? HTH, Nikos |
Reply |
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 |