Re: How to import multi-line record text file into Access?

Article View: comp.databases.ms-access

Article #11

Back to comp.databases.ms-access Previous Next

#11

From: Dudley
Date: Tue, 05 Jan 1999 00:00

24 lines
1095 bytes

This May be an option:
psuedo code

Open text file 
Open table 

add new record.
get line from file
put line in first field
get line from file
put line in second field

start over at the add record.


sorry about the sloppy responce. but you should get the idea.
if there are more than 2 line for each record just keep adding gets
until you complete the record

there may be a way to do your multi line import but I dont know how.


Reply to XXXXdudley@mail.auburn.net
Remove XXXX to reply

Technical Details

Message-ID: <36925161.9251923@news.mindspring.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3692698D.AE9@earthlink.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1668c5,36002617d1beb0ca
X-Google-Attributes: gid1668c5,public
X-Google-Thread: ff0ac,36002617d1beb0ca
X-Google-Attributes: gidff0ac,public
From: XXXXdudley@mail.auburn.net (Dudley)
Subject: Re: How to import multi-line record text file into Access?
Date: 1999/01/05
Message-ID: <36925161.9251923@news.mindspring.com>
X-Deja-AN: 429081518
References: <3692698D.AE9@earthlink.net>
X-Server-Date: 5 Jan 1999 17:50:52 GMT
Organization: MindSpring Enterprises
Newsgroups: comp.databases.ms-access,at.fido.msaccess

Reply to Parent Message