Received: by 10.66.81.195 with SMTP id c3mr8374970pay.44.1351381034017;
        Sat, 27 Oct 2012 16:37:14 -0700 (PDT)
MIME-Version: 1.0
Path: 6ni34576pbd.1!nntp.google.com!news.glorb.com!feeder.erje.net!eu.feeder.erje.net!news.mixmin.net!aioe.org!.POSTED!not-for-mail
From: The Frog <Mr.frog.to....@googlemail.com>
Newsgroups: comp.databases.ms-access
Subject: Re: Convert first record only
Date: Sun, 28 Oct 2012 10:36:24 +1100
Organization: Aioe.org NNTP Server
Lines: 16
Message-ID: <almarsoft.8917478325383121515@news.aioe.org>
References: <13b66c33-080c-4369-b61f-d3bfb8f6e454@googlegroups.com> <3a431308-16f2-4ff1-a88b-195ada9ada1e@googlegroups.com> <k6h8j5$6f8$1@dont-email.me> <8df165aa-6d56-4790-b971-8177938380ad@googlegroups.com> <k6he22$7qr$1@dont-email.me>
NNTP-Posting-Host: m87BUJ73kcvLzvvi6noNfQ.user.speranza.aioe.org
X-Complaints-To: abuse@aioe.org
User-Agent: Groundhog Newsreader for Android
X-Notice: Filtered by postfilter v. 0.8.2
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit

Wait a minute. A terabyte of data into Access from a csv? No way.

To do the cleanup and importing the OP is talking about they should 
be using a tool built for the job. This sort of thing needs data 
validation and process control, and most likely error handling and 
logging. This is ETL pure and simple. Do the heavy lifting where you 
can process it properly.

If you want to know more just say so here and I'll point you in the 
right direction. Punching through a terabyte of csv with vba and 
Access limited to 2 gigs is making very hard work of things.

-- 
Cheers

The Frog