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

Article View: comp.databases.ms-access

Article #10

Back to comp.databases.ms-access Previous Next

#10

From: john hayes
Date: Tue, 05 Jan 1999 00:00

20 lines
1598 bytes

I need to import a text data file which has 2 lines per record, into
Access.  I have tried the Import Wizard, but it does not seem to support
multi-line records.  I see that you can save/load a format spec 
for a file, but I didn't see if it saves the spec in a file that
I can manipulate (or create from scratch) - it seems to save the spec
internally?  Also, I don't know the syntax requirements for such a
spec file (not in the book).

Can anyone tell me how to tell Access that it needs to load multi-line
records from a text file?  BTW - editing the text file to make single-
line records is not an option, since the data file is created that
way by a canned vendor module and will have to be loaded periodically
on-going.

Also, is there a way to import without going through the Wizard?

Thanks!

John Hayes
aikosys@earthlink.net

Technical Details

Message-ID: <3692698D.AE9@earthlink.net>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,36002617d1beb0ca,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1668c5,36002617d1beb0ca,start
X-Google-Attributes: gid1668c5,public
From: john hayes <aikosys@earthlink.net>
Subject: How to import multi-line record text file into Access?
Date: 1999/01/05
Message-ID: <3692698D.AE9@earthlink.net>
X-Deja-AN: 429068623
Content-Transfer-Encoding: 7bit
X-Posted-Path-Was: not-for-mail
Content-Type: text/plain; charset=us-ascii
X-ELN-Date: 5 Jan 1999 16:35:42 GMT
X-ELN-Insert-Date: Tue Jan  5 08:55:08 1999
Organization: EarthLink Network, Inc.
Mime-Version: 1.0
Reply-To: aikosys@earthlink.net
Newsgroups: comp.databases.ms-access,at.fido.msaccess