Mr N - Latest Comments on Import and access to MySQL database, for a windows user https://www.bigsoft.co.uk/blog/?disp=comments en-GB http://backend.userland.com/rss 60 Dr Stephen Swift [Visitor] in response to: Import and access to MySQL database, for a windows user Tue, 01 Jul 2008 05:42:05 +0000 Dr Stephen Swift [Visitor] c165@https://www.bigsoft.co.uk/ <p>Dear Mr N,</p> <p>This was very helpful. I had a MySQL dump of a genomic/proteomic database to analyse (www.reactome.org). I have no skills in MySQL, but I do know MS Access. The database dump did indeed not create any databases. The description about how to link to Access was very handy. Once the tables were linked, all I needed was a few lines of MS Access VB code, to copy the linked tables over all &#8220;real&#8221; tables in another database, and I have now got a version of the database that I can use!</p> <p>Now the difficult part however - trying to understand the 169 tables! Off to find a biological interpreter&#8230;!</p> Dear Mr N,

This was very helpful. I had a MySQL dump of a genomic/proteomic database to analyse (www.reactome.org). I have no skills in MySQL, but I do know MS Access. The database dump did indeed not create any databases. The description about how to link to Access was very handy. Once the tables were linked, all I needed was a few lines of MS Access VB code, to copy the linked tables over all “real” tables in another database, and I have now got a version of the database that I can use!

Now the difficult part however - trying to understand the 169 tables! Off to find a biological interpreter…!

]]> https://www.bigsoft.co.uk/blog/2008/06/18/import-and-access-to-mysql-database-for#c165