Hi, > -----Original Message----- > From: Barbara Ferrell [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 26, 2001 10:11 AM > To: [EMAIL PROTECTED] > Subject: conceptual problem with ODBC and mysql > > > i am following 'SAMS teach yourself MYSQL in 21 days.. i have a conceptual > problem with how i am going to get the data from my microsoft Access > database and insert it into mysql tables. i thought i was going to use ODBC > but after reading lots of pages it looks like you use this program if you > continually wanted to access data on a windows server..which i am not going > to do...i just want my data out of the MSACCESS and into mysql on a linux > server.... my linux box is not connected to a network. my access database > is on the network. i have a cdrewritable and put access on it and some of > the data (it is only 12MB). now.... what in the heck do i do now? i don't > want to read anymore chapters and create a webpage and never use it again. > do i need to learn the ODBC stuff if i an never going to use windows again?
If I understood your problem correctly, you can export the desired tables and or data one time from Access to MySQL using MyODBC, the MySQL ODBC Driver. http://www.mysql.com/downloads/api-myodbc.html Here is the Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
