Ask the Expert

Importing fixed-width data

We are in the process of migrating a small Microsoft Access application and information from various mainframe sources onto MySQL. We have not found a reliable way on importing column-delimited data into a table in MySQL. The steps in your previous tip on this subject were not clear. Can you elaborate and also offer info on doing this in an environment like ours? I need to import a column-delimited table where each row is 400 characters wide. Is there a MySQL command, or series of commands, that will let me specify how to import the information contained in each row? For example, Social Security numbers are in columns 1-9, last names are in columns 10-30, first names are in columns 31-51, etc....?

    Requires Free Membership to View

Importing fixed-width data is a common request and, having answered it several times, I have an FAQ entry for it. You can check it out here.

See the original tip that inspired this question.

This was first published in July 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: