By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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....?