A number of upgrades occurred this weekend, the most noticible being Moveable Type, now running 2.661. What a number. The move from 2.64 was smooth, requiring no adjustments at all.
This past week I ‘struggled’ (mild term) with moving data from MS Access to a format I can easily dump into MySQL. A simple csv export should be sufficient, right? Not quite, this data has embedded linefeeds which ruins the export. Looks like I’ll have to write a linefeed replacement query in Access, run it to modify the data then do the export. Even then only part of the data migration is complete.
I’m moving the data to MySQL to allow me fuller access to the data. I cannot stand the programmability features of MS Access. The wizards are nice to an extend, and the RAD capabilities are great for mockups, but VBA seriously lacks the ease of use I need. Specifically I need to create an index of data entries. I have a list of words that I need to match to the entries, creating a link for each match.
The deseired result is beyond "simple" SQL statements, unfortunately, and I had enough messing around with VBA, ADODB and Access. Thus, putting it into MySQL, I can easily manipulate the data using PHP, Perl, Python or any of my other favorite languages.
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.