3 ms·
I sometimes fondly remember my time as an office hero, using MSAccess to attach to just about any data source imaginable, copy to a temptable and run whatever c
by stareatgoats 6y ago
I sometimes fondly remember my time as an office hero, using MSAccess to attach to just about any data source imaginable, copy to a temptable and run whatever cleaning was required before loading into the server database.
Good times; almost 25 years ago now. Sometimes I wonder if we're stuck.
- daniellarusso 6y agoI had actually considered doing this recently with a new hire. I purchased them a license with Access included, but ai have not had time to play with it to talk to MySQL 5.6.
- stareatgoats 6y agoIt is embarrassingly easy, once you get over the (minimal) hurdle of setting up the ODBC connections, docs over here for MySQL 5.6: https://dev.mysql.com/doc/connector-odbc/en/ https://dev.mysql.com/doc/connector-odbc/en/ In MSAccess, just go to "External Data" -> "New Data Source" -> "From Other Sources" -> "ODBC Databases" (chose whether to link or import the data) and then create a new data source under "Machine Data Sources" using the MySQL driver. It became like muscle memory after a while :-)