I used the export script for MSAcess and got my text file, ya , there are three tables in it. I have used LOAD DATA to import small single table info but how do I import ones with more tables properly. Do I create the tables first or how do I past into the monitor program. Using Windows version. Cheers database,sql,query --------------------------------------------------------------------- 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