Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Convert damaged MS access database into MySQL

Author  Topic 

somnika
Starting Member

1 Post

Posted - 2013-09-21 : 02:48:55
I was using MS access on Windows computer system for creating my database record. By mistake MS access has been crashed that's why i want to change my database record into MySQL.
Can anybody help me?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-21 : 14:36:47
quote:
Originally posted by somnika

I was using MS access on Windows computer system for creating my database record. By mistake MS access has been crashed that's why i want to change my database record into MySQL.
Can anybody help me?

If I understood your question correctly, you don't have Access installed on the computer anymore, but you have an Accdb file that you want to look at. You can try to connect to it using SSIS and import any data to SQL Server. I have not tried it in the scenario you are describing, so this suggestion is only an educated guess.
Go to Top of Page

arjeek
Starting Member

1 Post

Posted - 2013-09-23 : 01:39:48
You can use software from http://www.prodatadoctor.net/downloadsoftware/tools-to-convert-database/ms-access-to-mysql-conversion-program.html
I have never tried it, but may be you can solve your problem using this.
Go to Top of Page
   

- Advertisement -