🚀 go-pugleaf

Jordan, I'd do this two different ways.

1.  First, when you are in your access database, you can right click in the
tables view and select Import from the pop up menu.  You'll get a dialog box
that lets you select the file type (select .txt) and then browse to the file
in question and select it.  In the resulting import wizard, you'll be asked
questions about your text file.  Answer them but when you get to the point
where you can tell what type each field you import will be, you can also
check an option to skip certain fields.  I'd just check the option on fields
37-206 on the first import and the next time around, check the skip option
on fields 1-37 and 48-206, etc.  Each time making a new table.  In the end,
you would have a bunch of new tables, and each would only contain the data
from the select fields you had imported.

2.  The next way is to use a really good text editor.  I like textpad
because it has a block select mode.  I'd open the entire file, when I'd copy
a series of columns to the clipboard, and paste them into a new text file.
Create as many text files as you need to split up the original file and then
import those individually.

I have used both methods to accomplish what you are wanting to do and they
both take time, but there is really no other way to do it.  Good luck and I
hope this helps.

....Brad


"ASA GSI" <jbruce@asaglobalserv.com> wrote in message
news:bRXL5.52866$Z2.756820@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@asaglobalserv.com
>
>