No problem, Barbara. No ODBC required, either. I wish all my problems were this easy.
Basically you need to go back to your PC. Export your database as CVS files from Access (use TAB between fields, single quotes around each field, and newline at end-of record). Put each table into a file named after the table (e.g. tablename.txt). Then copy all those table text files onto your CDRW. Bring the CDRW onto your linux box and open it up by clicking the CD icon on the desktop or whatever you usually do. The data is now available in the unix directory /mnt/cdrom Now, go into mysql on your linux box. use CREATE TABLE to create a table for each file on your CD. I can't tell you what field types and sizes need to be there, you should make them similar to the tables in your ACCESS database. Preferably identical. Don't put any data into the table yet. And now, still in mysql, type: LOAD DATA LOCAL INFILE 'tablename.txt' INTO TABLE tablename do that once for each table file and you are DONE! For more details, see this page: http://www.mysql.com/doc/L/O/LOAD_DATA.html if there are some Barbara Ferrell wrote: > 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? > > > --------------------------------------------------------------------- > 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 > > > -- Steve Rapaport World Citizen --------------------------------------------------------------------- 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
