Skip to Main Content
Microsoft® Office Access 2003 Step by Step
book

Microsoft® Office Access 2003 Step by Step

by Online Training Solutions Inc.
August 2003
Beginner content levelBeginner
368 pages
10h 49m
English
Microsoft Press
Content preview from Microsoft® Office Access 2003 Step by Step

Importing Information from a Fixed-Width Text File

Importing Information from a Fixed-Width Text File

The only way to get the data of many older programs into Access is to export the data to a fixed-width text file and then import that file into Access. In a fixed-width text file, the same field in every record contains exactly the same number of characters. If the actual data doesn’t fill a field, the field is padded with spaces so that the starting point of the data in the next field is the same number of characters from the beginning of every record. For example, if the first field contains 12 characters, the second field always starts 13 characters from the beginning of the record, even if the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Access 2003 Inside Out

Microsoft® Office Access 2003 Inside Out

John L. Viescas

Publisher Resources

ISBN: 0735615179Supplemental ContentCatalog PageErrata