Databases :: MySql :: syncronising data between ms access and mysql using on-line scripts and FTP |
|||
By: ps14  |
Date: 21/09/2004 00:00:00  |
Points: 50 | Status: Answered Quality : Excellent |
|
Hi, I want to syncronise data between a ms access database and an on-line mysql database. I was thinking of: - generating a textfile for every changed record, or to export a complete table to a textfile from ms access. - Upload it to a directory on the webserver by ftp - use a script to import all data in this textfile into the database (update or add) The same should have to be possible in the other direction: extract the data from the mysql database and import it into the ms access database. Has anybody done this before? Can anybody help me with this? With writing the asp scripts? Many thanks in advance for you hints, tips and tricks! Peter |
|||
| By: VGR | Date: 21/09/2004 04:50:00 | |
Type : Answer |
| yes, you can do this. You can even ***perhaps*** directly make a front-end script (PHP, ASP, etc) that updates the MySql DB on the fly fromthe AccessDB somewhere else My solution would be : -given DB layout is established on both machines and is compatible : -from Access export the data in CSV format -upload it (FTP, HTTP, etc) to the machine running MySql in production -LOAD DATA INFILE 'yourupdate.csv' INTO table; see <A HREF="http://www.mysql.com/doc/en/LOAD_DATA.html">http://www.mysql.com/doc/en/LOAD_DATA.html</A> regards |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
