View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nikos Yannacopoulos Nikos Yannacopoulos is offline
external usenet poster
 
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