Jump to content


Photo

Member database, help


  • Please log in to reply
1 reply to this topic

#1 eric1980ca

eric1980ca
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 25 July 2003 - 09:53 PM

I need to create an online member database from an Excel file of 800 members. Can anyone suggest the best way to go about doing this? I\'m having trouble trying to figure out where to begin. Thanks.

-Eric

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 25 July 2003 - 11:58 PM

save the excel as a tab delimited text file and use mysqlimport, specifying that fields are separated with tabs.

http://www.mysql.com...ysqlimport.html
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users