Another helpful hint.
If you are getting out of memory or table creation errors when importing CSV or Excel files into MySQL using phpmyadmin, here is way to get the data imported.
1. Imported your txt/csv file to Excel.
2. Insert column names in the first row.
3. Save the Excel document as OpenDocument Spreadsheet and then import it into your database.