Could you use this in Access, perhaps ? SELECT * INTO mysql_table IN "" [ODBC;DSN=mysql_sample_DSN;SERVER=localhost;UID=root;PWD=] FROM access_table
You need myODBC 2.5 at least., and set up a DSN for your mysql database. It has worked fine for me with string, numeric and memo fields. It transparently change the datatype to mysql column types. ----- Original Message ----- From: "Donna Robinson" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 05, 2002 5:27 AM Subject: Re: MySql <- Access > FilterFodder: sql, query > > Hi Paul, > > I should have been more specific. My fault. > > I am running an app on a Linux box which uses a MySql dbase. Twice a year I > need to query an Access dbase running in a different building and get some > data from it across the network. I could conceivably query the Access dbase > from the app, and push the data into MySql perhaps? How can I do this? I > have no knowledge or understanding of Windoze worth talking about. > > Donna --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
