Re: Need desperate help!!

I would import the text file into a temp Access table. Then I would create Append queries to add the data from the temp table to the real ones.
Then I would code the whole procedure so it could be done with the click of a button every day.

--
Joe
Access MVP
Check out Dev Ashish's web site for answers to common questions
http://www.mvps.org/access/

ASA GSI <jbruce_at_asaglobalserv.com> wrote in message
news:bRXL5.52866$Z2.756820_at_nnrp1.uunet.ca...


> 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

>

>