Re: Trying to import several million rows- help!

From: Jamie Collins (jamiecollins_at_xsmail.com)
Date: 08/06/04 

Date: 6 Aug 2004 01:33:11 -0700

-=Drew wrote ...

> I know that Excel is not the optimal tool- my problem is that I need to go
> step by step to get the data into a DB- ultimately a SQL w/ Access Front End
> interface.

You may be able to use ADO to query the text file to get meaningful
in-memory *sets* of data:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting03092004.asp

Row-by-row processing must surely be impractical. How long have you
forecasted it will take you to step through 3 million rows? Are you
planning to transform you data with 3 million cell formulas? Don't hit
F9 <g>.

Jamie. 

--