Re: Need desperate help!!

Article View: comp.databases.ms-access

Article #163

Back to comp.databases.ms-access Previous Next

#163

From: Bob Thompson
Date: Thu, 02 Nov 2000 04:01

28 lines
2617 bytes

You can use the TransferText method of DoCmd - as in:

DoCmd.TransferText [transfertype][, specificationname], tablename, filename[,
hasfieldnames][, HTMLtablename]

by using a series of these DoCmd.TransferText commands you should be able to
write a filter which will direct the data where you want.


ASA GSI 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

Technical Details

Message-ID: <3A00E723.C30ED5C8@evilspammerhotsands.com.au>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!freenix!fr.usenet-edu.net!usenet-edu.net!fu-berlin.de!newsfeed.iinet.net.au!news.iinet.net.au!not-for-mail

References: <bRXL5.52866$Z2.756820@nnrp1.uunet.ca>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,9ea576d919b1ae68
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1034e6,9ea576d919b1ae68
X-Google-Attributes: gid1034e6,public
X-Google-Thread: f5691,9ea576d919b1ae68
X-Google-Attributes: gidf5691,public
X-Google-Thread: f4bf8,9ea576d919b1ae68
X-Google-Attributes: gidf4bf8,public
X-Google-Thread: 1143dd,9ea576d919b1ae68
X-Google-Attributes: gid1143dd,public
X-Google-Thread: 10bb27,9ea576d919b1ae68
X-Google-Attributes: gid10bb27,public
X-Google-Thread: 100e19,9ea576d919b1ae68
X-Google-Attributes: gid100e19,public
X-Google-Thread: 1131f0,9ea576d919b1ae68
X-Google-Attributes: gid1131f0,public
X-Google-ArrivalTime: 2000-11-01 20:02:55 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!freenix!fr.usenet-edu.net!usenet-edu.net!fu-berlin.de!newsfeed.iinet.net.au!news.iinet.net.au!not-for-mail
Message-ID: <3A00E723.C30ED5C8@evilspammerhotsands.com.au>
Date: Thu, 02 Nov 2000 12:01:40 +0800
From: Bob Thompson <bob@evilspammerhotsands.com.au>
Reply-To: bob@evilspammerhotsands.com.au
Organization: Hot Sands Productions
X-Mailer: Mozilla 4.75 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.ms-access,comp.databases.theory,cz.comp.databases.misc,microsoft.public.access.chat,microsoft.public.access.macros,microsoft.public.access.modulesdaovba,microsoft.public.access.queries,microsoft.public.access.reports,microsoft.publi
Subject: Re: Need desperate help!!
References: <bRXL5.52866$Z2.756820@nnrp1.uunet.ca>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 29
NNTP-Posting-Host: 203.59.91.56
X-Trace: news.iinet.net.au 973137681 22934 203.59.91.56

Reply to Parent Message