Article View: comp.databases.ms-access
Article #162Re: Need desperate help!!
From: Joe Fallon
Date: Thu, 02 Nov 2000 01:11
Date: Thu, 02 Nov 2000 01:11
32 lines
2721 bytes
2721 bytes
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@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 > >
Technical Details
Message-ID:
<uT97BmGRAHA.164@cppssbbsa05>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!cyclone2.usenetserver.com!news-out.usenetserver.com!news-peer.gip.net!news.gsl.net!gip.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!newsfeed.cwix.com!pullfeed!news.si.com!cppssbbsa01.microsoft.com!cppssbbsa05References:
<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: 1143dd,9ea576d919b1ae68 X-Google-Attributes: gid1143dd,public X-Google-Thread: f4bf8,9ea576d919b1ae68 X-Google-Attributes: gidf4bf8,public X-Google-Thread: f5691,9ea576d919b1ae68 X-Google-Attributes: gidf5691,public X-Google-Thread: 100e19,9ea576d919b1ae68 X-Google-Attributes: gid100e19,public X-Google-Thread: 10bb27,9ea576d919b1ae68 X-Google-Attributes: gid10bb27,public X-Google-Thread: 1131f0,9ea576d919b1ae68 X-Google-Attributes: gid1131f0,public X-Google-Thread: 1034e6,9ea576d919b1ae68 X-Google-Attributes: gid1034e6,public X-Google-ArrivalTime: 2000-11-01 17:12:59 PST From: "Joe Fallon" <jfallon1@nospamtwcny.rr.com> References: <bRXL5.52866$Z2.756820@nnrp1.uunet.ca> Subject: Re: Need desperate help!! Date: Wed, 1 Nov 2000 20:11:07 -0500 Lines: 34 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Message-ID: <uT97BmGRAHA.164@cppssbbsa05> 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 NNTP-Posting-Host: lph1-164.twcny.rr.com 24.92.252.100 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!cyclone2.usenetserver.com!news-out.usenetserver.com!news-peer.gip.net!news.gsl.net!gip.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!newsfeed.cwix.com!pullfeed!news.si.com!cppssbbsa01.microsoft.com!cppssbbsa05