Re: Need desperate help!!

Yes I do have a schema already in place and will be using primary and foriegn keys

Larry Linson <accdevel_at_my-deja.com> wrote in message news:8tpml6$9tm$1_at_nnrp1.deja.com...
> 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.
Received on Wed Nov 01 2000 - 20:05:15 CET