Article View: comp.databases.ms-access
Article #157Need desperate help!!
From: ASA GSI
Date: Wed, 01 Nov 2000 16:51
Date: Wed, 01 Nov 2000 16:51
17 lines
2294 bytes
2294 bytes
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:
<bRXL5.52866$Z2.756820@nnrp1.uunet.ca>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out.usenetserver.com!news3.bellglobal.com!news.uunet.ca!nnrp1.uunet.ca.POSTED!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 1143dd,9ea576d919b1ae68,start X-Google-Attributes: gid1143dd,public X-Google-Thread: f4bf8,9ea576d919b1ae68,start X-Google-Attributes: gidf4bf8,public X-Google-Thread: 1034e6,9ea576d919b1ae68,start X-Google-Attributes: gid1034e6,public X-Google-Thread: 10bb27,9ea576d919b1ae68,start X-Google-Attributes: gid10bb27,public X-Google-Thread: ff0ac,9ea576d919b1ae68,start X-Google-Attributes: gidff0ac,public X-Google-Thread: f5691,9ea576d919b1ae68,start X-Google-Attributes: gidf5691,public X-Google-Thread: 100e19,9ea576d919b1ae68,start X-Google-Attributes: gid100e19,public X-Google-Thread: 1131f0,9ea576d919b1ae68,start X-Google-Attributes: gid1131f0,public X-Google-ArrivalTime: 2000-11-01 08:50:20 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out.usenetserver.com!news3.bellglobal.com!news.uunet.ca!nnrp1.uunet.ca.POSTED!not-for-mail From: "ASA GSI" <jbruce@asaglobalserv.com> 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: Need desperate help!! Lines: 19 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Message-ID: <bRXL5.52866$Z2.756820@nnrp1.uunet.ca> Date: Wed, 1 Nov 2000 11:51:26 -0500 NNTP-Posting-Host: 216.94.12.130 X-Trace: nnrp1.uunet.ca 973097415 216.94.12.130 (Wed, 01 Nov 2000 11:50:15 EST) NNTP-Posting-Date: Wed, 01 Nov 2000 11:50:15 EST Organization: UUNET Canada News Reader Service