🚀 go-pugleaf

You could import it into a single table and then run Queries to create
or append to the other tables. That is, provided the total size doesn't
exceed Access 2000's limit of 2GB per database. You can, of course, use
tables in related database so that the limit really applies only to the
size of a single table plus the necessary overhead for a one-table
database.

Without more information, I can't be more specific, but I'd presume
that the multiple tables into which you want to put the information are
related by some common information.

You could, of course, open the file as a sequential file, open all the
pertinent Access tables, read it record by record, and append the
information to appropriate Access tables as you go along. But, it seems
to me there'll be a higher probablity of someting going awry while your
update is in progress if you take this approach.

  "ASA GSI" <jbruce@asaglobalserv.com> wrote:
> Hi
>
>  I an using Access 2000, I will be given a text file that I need to
import
> into Access, the run a report from that data.  The text file contains
> 399,000 records with approx. 206 fields that is delimitated with
commas.
> How do I import this text file into access, and into different tables.
>
> For example:
> Field1 - Field36 into table1
> Field37 - Field47 into table2
> ........
>
> I would like to use code but not sure the approach to accomplish this.
>
> Thank you in advanced.
> Jordan
> jbruce@asaglobalserv.com
>
>

--
 L. M. (Larry) Linson
  http://www.ntpcug.org - North Texas PC User Group - Visit and Join
  http://www.ntmsdevsigs.homestead.com - NTPCUG Developer SIGs
  http://homestead.deja.com/user.accdevel - Access examples


Sent via Deja.com http://www.deja.com/
Before you buy.