On Sat, 18 Jun 2005 13:50:56 -0700 nephish <[EMAIL PROTECTED]> wrote:
> Hey there, > > i have used the cgi module and dig it. > heres the deal, > my employer wants me to build a dynamic website that will access a > database and display customer > information on web. ok, easy enough. > heres the trick. > the database is MS Access. - ick. > what could i do to manipulate data in an access database ? can it be > done ? > all the research i have done just points me to sql, sqlite, etc... > i wouldnt mind if i can find a way to push everything from access to > another kind of database, > but i dont know where to start. > any ideas? > > -thanks > _______________________________________________ There is a way to work with your Access data via Python & the Jet engine, but I have no clue about that. Check the Python documentation - I'm sure that's where I saw reference to it. I may have seen it on one of the Python-related sites, but I think this link will offer some insight: http://www.python.org/windows/OdbcHints.html If you want to get out of Access, you can save your data as tab-delimited text files, and import them into MySQL. I'm sure that goes for PostGreSQL as well. Just make sure you remove the quote marks - regexp type work. (I haven't done that part programmatically yet, just using the find/replace feature of jEdit.) I'll have to cover that ground myself soon, so we'll see what happens. HTH, Don -- evangelinux GNU Evangelist http://matheteuo.org/ http://chaddb.sourceforge.net/ "Free software is like God's love - you can share it with anyone anytime anywhere." _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
