🚀 go-pugleaf

When you use the Import command, and specify a text file, the Import
Text Wizard will pop up. The wizard gives you the option of "skipping"
any field you like. So you can import certain fields to one table, then
re-run it and import other fields to another table, etc.

When you get to the last step in the wizard, click the "Advanced"
button, and then you can save the import spec and be able to use it
later. You'll end up with a different spec for each table you want to
import into.

HTH,
Frank

In article <bRXL5.52866$Z2.756820@nnrp1.uunet.ca>,
  "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
>
>

--
Frank S Pappalardo - www.fpappalardo.com
Troop/Pack 335 CR, SS Simon & Jude Church
Bethlehem, PA - Minsi Trails Council


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