Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 26th 06, 11:49 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2006
Posts: 26
Default 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   Report Post  
Old October 26th 06, 12:12 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

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
Create new excel table with filtered records from another table Berne van de Laar Excel Worksheet Functions 3 July 3rd 06 12:14 AM
Filter records in a table to extract to another table gams Excel Discussion (Misc queries) 0 May 9th 06 08:38 PM
Using Excel to change/add/delete records in Access database [email protected] Excel Programming 0 October 28th 04 03:29 AM
Is it possible to update records in an Access table from Excel? Mandy[_2_] Excel Programming 2 May 10th 04 02:36 PM
Adding Records to Access Table Mark[_22_] Excel Programming 0 November 25th 03 11:54 PM


All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017