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

Article View: comp.databases.ms-access

Article #15

Back to comp.databases.ms-access Previous Next

#15

From: Karl Gruber
Date: Wed, 06 Jan 1999 00:00

12 lines
1177 bytes

Hello John,
one other possibility consists in an import in a temporary table with
general spec's.
The second step: After this you can add this table with an query to the
correct table.
This query can consist with a condition for a character, which is
appearing in each first line with a relation to the correspond second
line. 
An other way of second step could be that create an relation of an
counter of the temporary table e.g. line x with the next line x+1
br
Karl gruber

Technical Details

Message-ID: <3693AB02.F9989C7D@ycom.at>

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: Karl Gruber <gruber@ycom.at>
Subject: Re: How to import multi-line record text file into Access?
Date: 1999/01/06
Message-ID: <3693AB02.F9989C7D@ycom.at>
X-Deja-AN: 429491125
Content-Transfer-Encoding: 7bit
References: <3692698D.AE9@earthlink.net>
Content-Type: text/plain; charset=us-ascii
Organization: CSO.Net Telecom Services, Vienna, Austria - not responsible for the content of this message!
MIME-Version: 1.0
Newsgroups: comp.databases.ms-access,at.fido.msaccess

Reply to Parent Message