Converting Microsoft Database (.accdb) to SQL (.sql)
I am wanting to convert my Access Database to a SQL Database and I wanted to know if anyone knew of any good, and free, programs that would do that.
I'm not wanting to turn the Access Database into a SQL Database and create a server and all that crap for it. I'm simply wanting to create a .sql file that I can upload onto my website's import wizard.
Re: Converting Microsoft Database (.accdb) to SQL (.sql)
Never had to convert between these two specific types, but have for others databases. In those cases I've used some free tools which facilitate the process. A quick google of "access to mysql" pulled up the following as well as a few others you might want to look into: Access To MySQL My recommendation would be to create a local test database that you can play with first, then when its wrinkle free upload to the production server.