To be sure, just add column headers to your excel sheet before you export it. Just make your headers match your field names.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:freeradius- > [EMAIL PROTECTED] On Behalf Of sarky > Sent: Wednesday, July 21, 2004 11:43 AM > To: [EMAIL PROTECTED] > Subject: Re: username's and password > > Thanx for the info, i know where to start from now. > > just a quick one if i use phpmyadmin how would i be able to tell it > for example username how will i be able to tell it which field to enter > username in? > > Thanx once more > > Sarky > > On Wed, 21 Jul 2004 17:24:40 +0100, Alain Perry wrote: > > 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, > > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
