ACC: Importing Fixed-Width Text with Embedded Carriage Returns (153373)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q153373
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you import or link a fixed-width text file with fields that contain
an embedded carriage-return and line feed control characters (ASCII decimal
values 13 and 10 respectively), Microsoft Access interpret this character
set as being the end of a record. The remaining portion of the record that
follows the CR/LF is considered the beginning of a new record.
CAUSE
The Import Wizard does not evaluate the field with the embedded or "soft"
return as part of the field's value.
RESOLUTION
To work around this behavior, create a custom import specification using
Schema.ini and then link the text file using Visual Basic for
Applications. Once linked, you can use a make-table or append query to
import the linked data.
For more information about using Schema.ini, please see the following
article in the Microsoft Knowledge Base:
149090 ACC: How to Use Schema.ini for Accessing Text Data
REFERENCES
For more information about importing fixed-width text files, please see the
following article in the Microsoft Knowledge Base:
94107 ACC1: How to Import Fixed-Width Text Files
For more information about accessing data in a text file, search in the
Help Index for "accessing text files," or ask the Microsoft Access 97
Office Assistant.
Modification Type: | Major | Last Reviewed: | 10/20/2003 |
---|
Keywords: | kb3rdparty kbprb KB153373 |
---|
|