Re: Need desperate help!!

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_at_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_at_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.