Best way to convert Access DB to MySQL? - GoFuckYourself.com

Rui · 07-13-2005, 11:51 AM

Suggestions appreciatted

cheers

psili · 07-13-2005, 11:56 AM

Don't know much about access. With that, I'd export the Access data into a delimited file of some sort (tab, comma), create a mySQL database that matches the schema of the access db and run the mysql "load data infile" command to inject the datafile into the new db.

newbreed · 07-13-2005, 11:59 AM

http://www.websitedatabases.com/access-mysql.html

Import your Access database to MySql, Even if a direct access to your MySQL database is denied.
If you need to import your Access database to a Mysql database to use it in your web site you may find a big problem if your hosting provider doesn't allow Remote connection to his MySQL servers (which is common), but you can always use Access-PHP-MySQL-Magic to overcome such restrictions.

SilverTab · 07-13-2005, 12:00 PM

what he said...you can just drop the data in a flat file... (CSV for example)...

if you want a program to do it for you there are several out there...
http://www.convert-in.com/acc2sql.htm is an example

BobG · 07-13-2005, 12:00 PM

I did this a while back and used a progaram that made it really easy. NOt sure if this is the one but there are several

http://www.convert-in.com/acc2mss.htm

http://www.google.com/search?sourcei...+access+to+sql

Rui · 07-13-2005, 12:35 PM

Thanks alot people

07-13-2005, 11:51 AM	#1
Rui web Join Date: Dec 2001 Location: On icq: 85-483-060 Posts: 9,533	Best way to convert Access DB to MySQL? Suggestions appreciatted cheers

07-13-2005, 11:56 AM	#2
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	Don't know much about access. With that, I'd export the Access data into a delimited file of some sort (tab, comma), create a mySQL database that matches the schema of the access db and run the mysql "load data infile" command to inject the datafile into the new db. __________________ Your post count means nothing.

07-13-2005, 11:59 AM	#3
newbreed Confirmed User Join Date: Nov 2003 Location: ThatOneProgram.com Posts: 9,898	http://www.websitedatabases.com/access-mysql.html Import your Access database to MySql, Even if a direct access to your MySQL database is denied. If you need to import your Access database to a Mysql database to use it in your web site you may find a big problem if your hosting provider doesn't allow Remote connection to his MySQL servers (which is common), but you can always use Access-PHP-MySQL-Magic to overcome such restrictions. __________________ Want to promote SUCCUBUS? Click HERE!!!! \| Want to buy SUCCUBUS? Click HERE!!!! Yeah, yeah, you know, That One Program! \| Want to trade links with StompBunny.com? Loryn ‎(3:16 PM): I love it, just as long as we keep the bedroom door closed from all ears then we can have throw down hard core sex that makes us money haha fuck it we can have sex on money never did that before Last edited by newbreed; 07-13-2005 at 12:00 PM..

07-13-2005, 12:00 PM	#4
SilverTab Confirmed User Join Date: Nov 2001 Location: MTL Posts: 5,060	what he said...you can just drop the data in a flat file... (CSV for example)... if you want a program to do it for you there are several out there... http://www.convert-in.com/acc2sql.htm is an example __________________ mmm my sig was too big... no more cool animation but hey still! need php? ICQ: 94586959

07-13-2005, 12:00 PM	#5
BobG Confirmed User Join Date: Nov 2003 Location: San Diego Posts: 4,274	I did this a while back and used a progaram that made it really easy. NOt sure if this is the one but there are several http://www.convert-in.com/acc2mss.htm http://www.google.com/search?sourcei...+access+to+sql

07-13-2005, 12:35 PM	#6
Rui web Join Date: Dec 2001 Location: On icq: 85-483-060 Posts: 9,533	Thanks alot people