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]