MySQL Question for you programmers... - GoFuckYourself.com

galleryseek · 01-26-2004, 11:18 AM

Is there ANYWAY to code a program, or a script..

that will take rows from an MS Access Database OR a RDBMS (Relational Database Management System) and transfer them to a MySQL Table???

I would really hate to have to enter all of the rows in by hand, seeing as to how theres approximately 6,500 of them with a bunch of columns in each.

thx

Libertine · 01-26-2004, 11:22 AM

Yes, and it should be fairly easy even.

jwerd · 01-26-2004, 12:14 PM

I can see what I can do. If you are interested, lets discuss the price and all that good stuff - [email protected]!

Thanks

woj · 01-26-2004, 12:18 PM

Export MsAccess data as text and then just import it into mysql.

fuzebox · 01-26-2004, 01:29 PM

The easiest way would be to export it in csv format, but alternatively you could write a script to do it. I did this once using libtds I think.

crunchyinmilk · 01-26-2004, 01:34 PM

set up a odbc connection to your mysql database (mysql odbc connector or whatever it's called off mysql.com)

link the mysql tables into ms access

do an insert query between your access table and the linked mysql table

make sure the column types are compatible. i've experienced issues going from mysql time/date into access date fields.

galleryseek · 01-26-2004, 01:35 PM

thx guys, i found a program that did it for me instantly.. worked perfectly.

01-26-2004, 11:18 AM	#1
galleryseek Confirmed User Industry Role: Join Date: Mar 2002 Posts: 8,234	MySQL Question for you programmers... Is there ANYWAY to code a program, or a script.. that will take rows from an MS Access Database OR a RDBMS (Relational Database Management System) and transfer them to a MySQL Table??? I would really hate to have to enter all of the rows in by hand, seeing as to how theres approximately 6,500 of them with a bunch of columns in each. thx

01-26-2004, 11:22 AM	#2
Libertine sex dwarf Join Date: May 2002 Posts: 17,860	Yes, and it should be fairly easy even. __________________ /(bb\|[^b]{2})/

01-26-2004, 12:14 PM	#3
jwerd Confirmed User Industry Role: Join Date: Jun 2003 Location: Costa Rica Posts: 1,953	I can see what I can do. If you are interested, lets discuss the price and all that good stuff - [email protected]! Thanks __________________ Yii Framework Guru - Seasoned PHP vet - Partner @ XXXCoupon.com

01-26-2004, 12:18 PM	#4
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	Export MsAccess data as text and then just import it into mysql. __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

01-26-2004, 01:29 PM	#5
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,123	The easiest way would be to export it in csv format, but alternatively you could write a script to do it. I did this once using libtds I think.

01-26-2004, 01:34 PM	#6
crunchyinmilk Registered User Join Date: Jan 2004 Location: florida Posts: 10	set up a odbc connection to your mysql database (mysql odbc connector or whatever it's called off mysql.com) link the mysql tables into ms access do an insert query between your access table and the linked mysql table make sure the column types are compatible. i've experienced issues going from mysql time/date into access date fields.

01-26-2004, 01:35 PM	#7
galleryseek Confirmed User Industry Role: Join Date: Mar 2002 Posts: 8,234	thx guys, i found a program that did it for me instantly.. worked perfectly.