Re: Importing Large List

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 10/16/04 

Date: Sat, 16 Oct 2004 10:06:23 +0100

If you have that many records then I am assuming they are in database format, in
which case if you have Access you could dump them in there and then query them
from Excel with a Pivot Table or just an ordinary MSQuery. You may even be able
to query them from Excel right where they are now, but it depends on where they
are stored.

Really depends what the data is and what you want to do with it, or get out of
it. 

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
              Sys Spec - Win XP Pro /  XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"marcrobin2004@hotmail.com" 
<marcrobin2004@hotmail.com@discussions.microsoft.com> wrote in message 
news:AD466C9C-D248-433C-8A13-1AB3950AF090@microsoft.com...
> How do I import a list that is over 200,000 records?  I can bring in 65000
> records but no more.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.778 / Virus Database: 525 - Release Date: 15/10/2004
Quantcast