Importing Fixed Width Data

[twilson]

I have a data file with 79 fields and 600 rows of fixed width data. I know the exact specs on the data, and if I make a database that will hold it all, is there an easy way (without having to write a program to go line by line splitting off chunks of data) to import it into a MySQL DB?

Thanks,
Tom 🙂

[barand]

If you have MSAccess, import into that and use 'MyAccess' add-in to load into MySQL. That's the easiest method I know without coding.