Re: how to update a mysql table from access

2005-07-14 Thread nephish
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

Re: how to update a mysql table from access

2005-07-14 Thread nephish
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

Re: how to update a mysql table from access

2005-07-14 Thread SGreen
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

how to update a mysql table from access

2005-07-13 Thread nephish
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

Re: how to update a mysql table from access

2005-07-13 Thread mos
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.

Re: how to update a mysql table from access

2005-07-13 Thread nephish
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

Re: how to update a mysql table from access

2005-07-13 Thread mos
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