Re: Need desperate help!!

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_at_nnrp1.uunet.ca>,   "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
>
>

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