Question:
Access 2007 DB file dump to txt or sql?
john
2009-12-01 02:20:44 UTC
I've got a Access 2007 file and am wondering if there is a way to dump it's data to a txt file or mysql structure. I've searched for software but they all just do transfers between live databases.

It's a .ACCDB file. I can build off the dump using python so clutter isn't a problem. I'll go after I post this to look and see if there is a python library to load it. It's not pass protected either.

Thanks in advance.
Three answers:
mark r
2009-12-01 13:03:33 UTC
Have a look at the mysql migration kit.

http://dev.mysql.com/doc/migration-toolkit/en/index.html



I have used that to transfer data straight from access (2003) to Mysql.

I would expect it to be able to handle 2007.



I think it has an option to create scripts rather than do an actual insert but I could be wrong.



there are some oddities around the field data types (e.g. Yes/No ) but it should be able to do the job.
Makiavel
2009-12-01 11:27:10 UTC
You can transfer all the MS Access Database into Microsoft SQL Database Server going to Tools>Database Utilities>Upsizing Wizard, and following the instructions
galeano
2016-11-14 12:23:50 UTC
attempt to transform them to unix timestamp format (form of seconds from January 1st, 1970). there would desire to be a function that does this for you (and back from it). then the assessment is easy, you in simple terms evaluate integers, and you may actual do date manipulations (ie a million day = 86400 seconds)


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...