Maljonic
Can't get enough of FH
- Joined
- Dec 22, 2003
- Messages
- 1,297
I've been using Excel to edit a MySQL database then saving it as a tab delimeted text file, then having to go through the file and removing unwanted speech marks before SQLing it back into the database, which is a pain but loads quicker than editing entries one at a time.
Anyway I'm about to do the same again with a dictionary and wondered if there is better software to use than excel where I can edit stuff in columns exactly the same but where it saves/exports the data in a text file that can be run as an SQL thingy right away. Or if there's a better way of saving stuff in Excel, or exporting and importing through PHPMyadmin?
I'm wanting to convert the static dream dictionary here: http://www.maljonicsdreams.com/Dream_Dictionary/ into a database driven job, something I would have done in the first place if I'd known what I was doing three years ago.
Anyway I'm about to do the same again with a dictionary and wondered if there is better software to use than excel where I can edit stuff in columns exactly the same but where it saves/exports the data in a text file that can be run as an SQL thingy right away. Or if there's a better way of saving stuff in Excel, or exporting and importing through PHPMyadmin?
I'm wanting to convert the static dream dictionary here: http://www.maljonicsdreams.com/Dream_Dictionary/ into a database driven job, something I would have done in the first place if I'd known what I was doing three years ago.