Le mer 21/07/2004 à 17:08, sarky a écrit : > I have an excel sheet with 10,000 username's and password and i am trying to import > them > into mysql databse, does anyone out there know of a way to do it..
You can save it as a .CSV file (using file->save as...) in excel, and then make a script using your favorite language or use phpmyadmin to import it into mysql. You may also be able to import directly using the MySQL ODBC driver that allows MS Office to exchange data with it IIRC. Hope this helps, -- Alain Perry - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
