Table dump text file conversion method
This method is aimed at data transfer from Microsoft Access to MySQL. The process will lead to data from a single Microsoft Access table being converted into a set of queries that will modify an existing and matching MySQL table. Only the field count must match exactly, but you must pay carefuly attention to file types.
- Create a table with the same field structure as your source table
- Add a temporary field to the very start of your source table
- Fill every record in this new field with the § (section symbol, Alt+21) character
- Export the table as a text file
- Make sure that there is no text delimiter
- Make sure that the field delimiter is the | symbol (vertical bar, Alt+124)
- Open your exported table then copy and paste it all into the converter script below:
|
Instructions 
