Re: how to update a mysql table from access
wow thanks ! this i can do. was just downloading python for windows, will still keep it, may be usefull one day, but i would lot rather update via access. thanks again. nephish On Thu, 2005-07-14 at 09:18 -0400, [EMAIL PROTECTED] wrote: If you have your native, auto-updated table in MS Access and a different Linked table pointing to the MySQL copy of it in the same database, just build an Access query that will INSERT or UPDATE (as appropriate) your linked table with data from your native table. No scripting required, just the internal data manipulation of Access. Consult the MS Access help files or any number of online resources for instructions on how to build a query in access that copies data from one table to another. Shawn Green Database Administrator Unimin Corporation - Spruce Pine nephish [EMAIL PROTECTED] wrote on 07/13/2005 10:32:19 PM: you mean like in a script? the windows computer runs access, which i am not very familiar with and was able to accomplish what i have done so far by lots o' docs at the mysql.com site. sorry for the newbie-ness of this question. i am somewhat familliar with python, maybe there is a module i can use for this.. thanks, On Wed, 2005-07-13 at 22:10 -0500, mos wrote: At 08:51 PM 7/13/2005, you wrote: Hey there, thanks to some help i have received right here, i have been able to access a mysql database on a linux computer from MS access on a windows computer, i was able to connect and create the tables and export all rows correctly.. i used MyODBC from mysql. ok, here is the deal, the access database gets info from another program and adds new rows every 15 seconds or so, i need some automated way to sync the two databases together every oh,,, 5 minutes or so. there is lots of documentation on how to do this by linking a table to a mysql table, however, when i do this, the access table is the one that gets updated, not the mysql table (deletes any info received since last update) and still does not provide a way to do this automatically. I cant find way to do it anywhere, little or no docs.. or i am looking in the wrong place. thanks for reading this, hope someone can help Have you tried prefixing the MySQL table with the MySQL database name? Example: select * from MySqlDb1.Table1; insert into MySqlDb1.Table1 (cust_id, cust_name) values(1,John Smith); Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to update a mysql table from access
Hey thanks for the link, yep, i guess i am going to have to write something up in python. (or maybe be lucky enough to find something i can modify from hotscripts :) . i may check out that piece called Navicat. saw some reviews of it and it may have what i need also. thanks again nephish On Thu, 2005-07-14 at 00:25 -0500, mos wrote: At 09:32 PM 7/13/2005, you wrote: you mean like in a script? the windows computer runs access, which i am not very familiar with and was able to accomplish what i have done so far by lots o' docs at the mysql.com site. sorry for the newbie-ness of this question. i am somewhat familliar with python, maybe there is a module i can use for this.. thanks, You can use any language you like. I would have assumed you would use the same language that you used to access your Access database. Something like Visual Basic., Delphi, PHP, Perl, Python etc..You could even use MySQL.exe and execute an SQL script on that for something that is quick and dirty, but I wouldn't recommend it because you have no error checking capability (in other words you have no way of knowing if the script succeeded or not). http://sourceforge.net/projects/mysql-python Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to update a mysql table from access
Hey there, thanks to some help i have received right here, i have been able to access a mysql database on a linux computer from MS access on a windows computer, i was able to connect and create the tables and export all rows correctly.. i used MyODBC from mysql. ok, here is the deal, the access database gets info from another program and adds new rows every 15 seconds or so, i need some automated way to sync the two databases together every oh,,, 5 minutes or so. there is lots of documentation on how to do this by linking a table to a mysql table, however, when i do this, the access table is the one that gets updated, not the mysql table (deletes any info received since last update) and still does not provide a way to do this automatically. I cant find way to do it anywhere, little or no docs.. or i am looking in the wrong place. thanks for reading this, hope someone can help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to update a mysql table from access
you mean like in a script? the windows computer runs access, which i am not very familiar with and was able to accomplish what i have done so far by lots o' docs at the mysql.com site. sorry for the newbie-ness of this question. i am somewhat familliar with python, maybe there is a module i can use for this.. thanks, On Wed, 2005-07-13 at 22:10 -0500, mos wrote: At 08:51 PM 7/13/2005, you wrote: Hey there, thanks to some help i have received right here, i have been able to access a mysql database on a linux computer from MS access on a windows computer, i was able to connect and create the tables and export all rows correctly.. i used MyODBC from mysql. ok, here is the deal, the access database gets info from another program and adds new rows every 15 seconds or so, i need some automated way to sync the two databases together every oh,,, 5 minutes or so. there is lots of documentation on how to do this by linking a table to a mysql table, however, when i do this, the access table is the one that gets updated, not the mysql table (deletes any info received since last update) and still does not provide a way to do this automatically. I cant find way to do it anywhere, little or no docs.. or i am looking in the wrong place. thanks for reading this, hope someone can help Have you tried prefixing the MySQL table with the MySQL database name? Example: select * from MySqlDb1.Table1; insert into MySqlDb1.Table1 (cust_id, cust_name) values(1,John Smith); Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: beginner needs help servin up a lan
Well thanks, these look as if to be exactly what i have been looking for. will test this stuff out when i get to work, thanks again. On Tue, 2005-07-12 at 10:10 +0300, Gleb Paharenko wrote: Hello. These links could be helpful: http://dev.mysql.com/doc/mysql/en/export-of-data.html http://dev.mysql.com/doc/mysql/en/mysql-tools-with-access.html For more information search in archives at: http://lists.mysql.com/mysql nephish [EMAIL PROTECTED] wrote: Hello there i need to import an entire database or find a way to get all the info in a microsoft access .mdb database into a MySQL database. here is another trick, the access database is on an WinXP computer, the MySQL database is on a debian linux computer. They are on the same internal network though. is this even possible ? if so, where can i read up on how to do it? thanks, shawn -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
beginner needs help servin up a lan
Hello there i need to import an entire database or find a way to get all the info in a microsoft access .mdb database into a MySQL database. here is another trick, the access database is on an WinXP computer, the MySQL database is on a debian linux computer. They are on the same internal network though. is this even possible ? if so, where can i read up on how to do it? thanks, shawn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
offer a solution ?
Hey there, i have been messing around with MySQL for a little bit now. I have a question about how i might could do something. i am writing a database to track what a bunch of electric monitors are doing. the status of the monitor changes almost daily. i need access to each monitor, when it changed, and i also need to track its history. Easy enough. but if i update a row in a table, i loose the old info. So i kinda cannot create a table referenced by a key of monitor number... i think that the easiest way, would be to create a seperate table for each monitor... but there are almost a thousand monitors... will that become a nightmare ? can MySQL handle that kind of thing? a thousand tables in one database ? i have to be able to access each change in its history. how should i set this up? thanks for any suggestions. shawn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]