|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 13th, 2002, 08:21 PM
|
|||
|
|||
|
Converting from Access to mysql
Hello Everyone,
I am looking for options (tools or methods) that will allow me to update a mysql driven website from a local access database. The local database will have far more info. but I want to be able to extract pertinent info from this database to update the mysql website database. What tools or methods are available and what are your recomendations? Many Thanks Peter
|
|
#2
June 13th, 2002, 09:44 PM
|
|||
|
|||
|
Since I don't know any other way to do it, I would export the data from Access in a delaminated text format and then use a script to import into to Mysql.
__________________
Have Eternal Life Learning is so unproductive... The more I learn the more questions I have! Therefore I am going backwards. Have Eternal Life PHP Version 5.1.4 MySQL version: 5.0.27-standard
|
|
#3
June 14th, 2002, 06:09 AM
|
||||
|
||||
|
__________________
UN*X is sexy! who | grep -i blonde | date; cd ~; unzip; touch; strip; finger; mount; gasp; yes; uptime; umount; sleep
|
|
#4
June 14th, 2002, 06:14 AM
|
||||
|
||||
|
I think that you need a macro that extracts the new data (found trough a timestramp or other) and inserts into mysql trough odbc link.
Hope this helps.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#5
June 14th, 2002, 11:20 AM
|
|||
|
|||
|
There are several Access-to-MySQL converters available:
http://www.mysql.com/downloads/contrib.html (In the 'Converters" section, there are several text files containing Access macros which create appropriate SQL statements for MySQL) http://www.mysql.com/portal/softwar...ware-37-1.html. (Some are freeware, some are commercial.)
__________________
The real n-tier system: FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL Amazon wishlist -- rycamor (at) gmail.com
|
|
#6
June 18th, 2002, 08:32 PM
|
|||
|
|||
|
Converting from Access to mysql
Thank you everyone for your help. I not only found a nice
shareware access2mysql package which works both way very well, but I also found the link:- http://www.devshed.com/Server_Side/MySQL/ODBC very usefull, it turns out I needed both the tool and the ODBC connectivity. Many Thanks Peter Newton
|
|
#7
June 20th, 2002, 02:11 PM
|
|||
|
|||
|
i wonder if there's a way to have a permanent synchro between an access database and a mysql one?
From what i understand ODBC gives u the possibility to make the link between the two; is there a way to connect em permanently?
__________________
|
|
#8
March 11th, 2004, 06:32 AM
|
|||
|
|||
One more tool to look at
hi folks, here is one more tool to look at:
http://www.data-conversions.net i like this one the most... having found this thread, hope to make an ad for them - great team with fast and good support... best regards 
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Converting from Access to mysql |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
